XYplorer Beta Club
Instead I will describe the desired end result.
Imagine an Excel file listing all the files in a directory and all its sub directories.
The First column would be a hyperlink, when you click on the hyperlink it opens the file.
The second column would be the file name.
The third column would be where you can enter notes about the file.
The existing report csv format makes it difficult to create this. I suggest a new optional format that would make this easier.
What I do at the moment is to use a batch file containing the command.
dir /S /B /W >> list.txt
The resulting Text file is then cut and pasted into an Exccel spreadsheet and after much messing about with excel formulae etc I am able to use the following Macro to convert a column into shortcuts.
Code: Select all
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/05/2007 by Graybeard '
' Keyboard Shortcut: Ctrl+j (must be manually assigned to this macro) ' Click on a cell. Hold down Ctrl and J. Turns all cells in column into Hyperlinks.
Dim CellValue As String ' Variable to remember cell value
CellValue = ActiveCell.Value 'Copy cell value into Variable
' Create Hyperlink based on cell value
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=CellValue, _
TextToDisplay:=CellValue
ActiveCell.Offset(1, 0).Activate 'Jump down one to next cell
End SubDonald Lessau has suggested that I post this on this Forum and see if anyone else would find this useful.