| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Path and Number of files in a folder. - Pass to Macro.
Hi Richard
I have a few examples here that you can use maybe http://www.rondebruin.nl/ado.htm See also the links on the page to other useful pages -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
