Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get series of files to open from same folder
I raised a query similar to this before and was given some
code along the follwoing lines: Workbooks.Open FileName:=ThisWorkbook.Path & "\userfile.xls" The difference this time I am wanting to open a series of files from the given folder. Any help would be appreciated. TIA Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get series of files to open from same folder
Ron,
You'd have to open them sequentially, using the same coding that you were given: Workbooks.Open FileName:=ThisWorkbook.Path & "\file1.xls" Workbooks.Open FileName:=ThisWorkbook.Path & "\file2.xls" Workbooks.Open FileName:=ThisWorkbook.Path & "\file3.xls" Another option would be to save the open workbooks as a "Workspace" Then whenever you open the workspace, all the files in the workspace will be opened together. John Ron McCormick wrote: I raised a query similar to this before and was given some code along the follwoing lines: Workbooks.Open FileName:=ThisWorkbook.Path & "\userfile.xls" The difference this time I am wanting to open a series of files from the given folder. Any help would be appreciated. TIA Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get series of files to open from same folder
How would we determine the series. Do you want to open all the files in
the folder, or those meeting certain criteria in terms of their name. In any event, look at the sample for the Dir command in VBA. That is a good start. -- Regards, Tom Ogilvy "Ron McCormick" wrote in message ... I raised a query similar to this before and was given some code along the follwoing lines: Workbooks.Open FileName:=ThisWorkbook.Path & "\userfile.xls" The difference this time I am wanting to open a series of files from the given folder. Any help would be appreciated. TIA Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you set Excel 2007 to open files in a specific folder? | Excel Discussion (Misc queries) | |||
can't open excel files from common folder | Excel Discussion (Misc queries) | |||
Can't Open Certain Excel Files in Folder | Excel Discussion (Misc queries) | |||
create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
open all files in a folder and ... | Excel Programming |