Hi


"solrac1956" wrote in message
...
Arvi Laanemets;

Thank you for your help. Please clarify;

1.) What is the Excel Worksheets Module?

NB! WORKBOOK's module!

Open your Excel workbook. Activate VBA editor (Alt+F11). Unless you have
some module in workbook (you can see them in VBA project window at top left
corner in modules section of your project, i.e your workbook), insert one
(select Module from Insert menu). When the module isn´t activated jet (VBA
editor window is empty), then activate the module (double-click on it in VBA
project window). Copy function(s) into module. Vlose VBA editor.


2.) What Aruments should I watch for?

For GetMyFile():
1) Full path of folder, from where file names are retrieved, enclosed in
quotes;
2) The order number of file of searched type in this folder (1 - first;
2 - second etc.);
3) the file extension, enclode in quotes - determines file type the
search is performed for.




"solrac1956" wrote:

How do I import Names of Windows files or folders into an Excel Spread
sheet?

Please e-mail me at