Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Path and Number of files in a folder. - Pass to Macro.
My OS is MS XP.
Using Excel 2000 I am using XLM GetValue to extract data from Excel Files. I need the path and file name to the files. Problem is the file names and number of files change each month. I need to pass the Path and file names to GetValue without knowing B/4 hand the name or number of files. The files all reside in one folder. Thanks in advanced. -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel VBA to manage outlook attachments 2003 | Excel Discussion (Misc queries) | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
Macro help: File path in Excel 2000 | Excel Discussion (Misc queries) | |||
extract key words/data from multiple files -dump in new worksheet | New Users to Excel |