Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen different files in a loop
I want to use the progression display while it is opening 6 different files
then refresh them then close them I am hoping there is a way to do this through a loop bUT CANT FIGURE OUT how to open different files names in the loop thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen different files in a loop
What progression display?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CmK" wrote in message ... I want to use the progression display while it is opening 6 different files then refresh them then close them I am hoping there is a way to do this through a loop bUT CANT FIGURE OUT how to open different files names in the loop thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen different files in a loop
Progrssive indicator?
"Bob Phillips" wrote: What progression display? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CmK" wrote in message ... I want to use the progression display while it is opening 6 different files then refresh them then close them I am hoping there is a way to do this through a loop bUT CANT FIGURE OUT how to open different files names in the loop thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen different files in a loop
So do you want to share it with us?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CmK" wrote in message ... Progrssive indicator? "Bob Phillips" wrote: What progression display? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CmK" wrote in message ... I want to use the progression display while it is opening 6 different files then refresh them then close them I am hoping there is a way to do this through a loop bUT CANT FIGURE OUT how to open different files names in the loop thanks in advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen different files in a loop
Something like
sub test dim doc(1 to 6) as string doc(1)= "file1 name" doc(2)= .. .... for x =1 to 6 workbooks.open doc(x) ... workbooks(doc(x)).close True Next Untested Regards JY "CmK" wrote in message ... Progrssive indicator? "Bob Phillips" wrote: What progression display? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CmK" wrote in message ... I want to use the progression display while it is opening 6 different files then refresh them then close them I am hoping there is a way to do this through a loop bUT CANT FIGURE OUT how to open different files names in the loop thanks in advance |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
OPen different files in a loop
If you mean you want a progress bar to display how your code is progressing
then something like at the end of the link below could be incorporated into the workbook that contains the code to do all the opening and closing. http://www.cpearson.com/excel/Progress.htm "CmK" wrote: I want to use the progression display while it is opening 6 different files then refresh them then close them I am hoping there is a way to do this through a loop bUT CANT FIGURE OUT how to open different files names in the loop thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
open files in loop with date order | Excel Discussion (Misc queries) | |||
Loop through ".DAT" files, open run code, close next | Excel Programming | |||
Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
IF wokkbook1 is open, open workbook2 Loop | Excel Programming |