Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open multiple HTML files in succession
I'm trying to strip data from several hundred HTML files with names
File1.htm, File2.htm, File3.htm, etc. I've written the macro to strip the data (opening the file as a text file, or importing the data with a query, works both ways) but get stuck trying to write the code to open each file in turn, close it once I've copied the data into a worksheet, then open the next file (and ultimately stop once every file in the directory has been handled). All help appreciated - I'm trying to make the jump from 4.0 macros (where this would be pretty easy) to VBA so please be gentle! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining multiple Excel files into one html? | Excel Programming | |||
Combining multiple Excel files into one html? | Excel Programming | |||
Combining multiple Excel files into one html? | Excel Programming | |||
How to open large HTML FILES IN EXCEL In quick Time | Excel Programming | |||
How to open large HTML FILES IN EXCEL In quick Time | Excel Programming |