Okay, here we go:

The code I have written so far opens a range of workbooks selected by
multi-select listbox and single-select listbox.

Now I want to apply formatting to the opened workbooks, includin
adding worksheets, setting autofilters sorting the data and then savin
the workbooks as .xls files.

Example:
VB has opened files File1_a.csv, File1_b.csv and File1_c.csv from th
first (multi select) listbox and File2_a.xls from the (single select
listbox, so 4 files have been opened.

Now I want to call function1 to format all open File1_*.csv files an
copy-paste File1_*.csv ranges into different sheets of the File2_a.xl
file.

Function1 contains code as recorded in Excel.

Can I declare/activate open workbooks by name (such as File1_*.csv) an
then call the function on each individual open workbook meeting th
file name criteria?

I am eternally gratefull to anyone who can help me further on thi
(last for my current project) vb problem!

Thanks,
Joos

--
Message posted from http://www.ExcelForum.com