VBA to Open Group of Workbooks Based on Name and Filepath
What I want to do is create a Macro that opens a group of workbooks from a list of names and filepaths in columns A and B. I want column A to have the names of the files, and column B to have the filepath/location of where the files are stored. The macro would then go through and open all files.
Any suggestions on what code would work?
Thank you for the help, I really appreciate it!
Thanks,
J
Last edited by Jason Carlos; 05-20-2014 at 02:40 PM.
Hi Jason
It'll be something like this
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
The code works great, every file opens but after I get an error stating:
"Run-time error '1004':
'C:\' could not be found. check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved or deleted."
Just to reiterate, this is after every file opens.
Hi Jason
Do you have anything else in Columns A or B other than the File Names and Paths?
I have headers that say "Name" and "Filepath." I also have a concatenate formula that combines the files name I post in column C with ".xlsx" so if finds the formula. I uploaded an example of the worksheet. I also changed the code too:
This way it pulls from the ws named "filepath"Please Login or Register to view this content.
Hi Jason
How does Column C get populated?
Hi Jason
Assuming you're populating Column C I'd suggest modifying the Code. Column A is filled with Formulas so we can't use Column A.
Please Login or Register to view this content.
That is where I manually enter in the file name. The way I do that is by clicking on the file in a folder pressing F2 and the copy/pasting into excel. Because this doesn't paste the extension .xlsx in there, that is why I have the concatenate formula in column A
Hi Jason
Is the extension always .xlsx?
If so, use this CodePlease Login or Register to view this content.
You are the man!
Solved!
You're welcome...glad I could help. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks