Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open all Text files in a folder
Hi there, Just wandering if anyone can help me out. I'm looking for a method of opening all text files in a folder. I'm still pretty new to vba/macros - so not sure if this is possible. I have tried googling and using the office vba help file to no avail. It seems a filename is required when opening a document in excel using vba. I have tried changing the filename to *.txt - which works but only opens the first file then stops. Would it be possible to use some sort of count function to open them all? Cheers Rob -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=526961 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open files in folder - skip if already open | Excel Programming | |||
Open all files in a folder | Excel Programming | |||
Open Excel files in a folder | Excel Programming | |||
Open Excel files in a folder | Excel Programming | |||
open all files in a folder and ... | Excel Programming |