Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I copy file names into cells
I would like to have a macro that if I execute it, it will copy all the existing file names from a specified directory into individual cells in the sheet. each individual file name will be hyperlinked, if I click on it, the file should open (they could be Word or pdf files..etc..) I really appreciate your help in advance Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any way to copy file names in windows explorer & paste into Excel? | Excel Discussion (Misc queries) | |||
How to keep names defined after a copy? | Excel Discussion (Misc queries) | |||
need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
file will not open | Excel Discussion (Misc queries) |