Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using macro to open every file in a folder
I need to open a file, copy a few lines and close it. then open th next. I know how to do all that except getting the loop to open th next file automatically. The trouble is that i don't know how man files might be in the folder. it might be 4 or 5, but it might be up t 10 or 11. any suggestions? thanks, richar -- wraithlea ----------------------------------------------------------------------- wraithlead's Profile: http://www.excelforum.com/member.php...fo&userid=1157 View this thread: http://www.excelforum.com/showthread.php?threadid=27269 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using macro to open every file in a folder
Richard,
there is an example at http://tinyurl.com/67tfh -- HTH RP "wraithlead" wrote in message ... I need to open a file, copy a few lines and close it. then open the next. I know how to do all that except getting the loop to open the next file automatically. The trouble is that i don't know how many files might be in the folder. it might be 4 or 5, but it might be up to 10 or 11. any suggestions? thanks, richard -- wraithlead ------------------------------------------------------------------------ wraithlead's Profile: http://www.excelforum.com/member.php...o&userid=11578 View this thread: http://www.excelforum.com/showthread...hreadid=272696 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Fileopen folder | Setting up and Configuration of Excel | |||
Open each file in a folder and closing it | Excel Discussion (Misc queries) | |||
Macro to open most current file in folder | Excel Discussion (Misc queries) | |||
Unable to open a file from its icon in folder | Excel Discussion (Misc queries) | |||
Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) |