Hello I am new to the forums and have a quick question on opening multiple files using a macro.
At the moment I am altering a previous macro that opened an excel file and imported the data into a template that then did some number crunching and created a graph. I am now trying to do the same thing but with multiple files at one time.
Also I am currently using Application.FindFile command to open the file.
Application.FindFile Set temp= Application.ActiveWorkbook
Hello toggel,
Welcome to the Forum!
There is some information missing from post. Let's start with the files.
1. Do you know where these are located (disk, directory, etc.)?
2. Will the user be selecting them from a dialog?
3. Will these files be Excel workbooks (.xls extension)?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Yes they know where the files are located, Yes they will be selecting them from the dialog , and yes they are all single paged workbooks. Now from what I know that command will open the workbooks but after that is there a way to set them into a dynamic array which i can then loop the rest of my macro through?
something like
or is it not possible to make an array of workbooks?Application.FindFile set temp()=Application.ActiveWorkbook
Last edited by toggel; 06-19-2009 at 04:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks