| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Statement for opening multiple files of type?
I am trying to write a VB script in Excel that will open up all files with a
..rpt extension, then format them in a particular way, then save them as .xls files in a separate folder. I have been able to script the formatting of the opened files, but I would like Excel to open all the files in a certain folder that has the .rpt extension. Any suggestions on how to write this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening multiple files into one workbook, but multiple worksheets.... | Excel Discussion (Misc queries) | |||
| opening multiple .txt files from multiple folders | Excel Discussion (Misc queries) | |||
| How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
| Opening Multiple Files | Excel Programming | |||
| opening multiple .csv files from the web | Excel Programming | |||
Threaded Mode
