Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list Workbooks in Current Folder
hi all,
your help is mostly appreciated for following: i have a dedicated folder (called "Project" for example) which has following Workbooks: Workbook1 Workbook2 Workbook3 and most important MasterWorkbook now i would like to have a macro which is executed in the MasterWorkbook that will generate the list of all the Workbooks in the folder where the MasterWorkbook resides ("Project" folder in this example) except for the MasterWorkbook itself on a specific sheet (called "Workbook Overview" for example). in this example on MasterWorkbook.Workbook Overview the list would be as follow: Workbook1 Workbook2 Workbook3 thanking you for your time - cheers... ....jurgenC! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use current file and folder name | Excel Discussion (Misc queries) | |||
extract from multiple workbooks in a folder | Excel Discussion (Misc queries) | |||
Macro to open most current file in folder | Excel Discussion (Misc queries) | |||
Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) | |||
Excel should open documents in the folder of the current file | Setting up and Configuration of Excel |