Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA and Multiple Excel Files
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA and Multiple Excel Files
Resolved · Low Priority · Version 2003
Reply Thu 2 Apr 2009, 16:50Delegate Matthew said...
Matthew has attended:
Excel VBA Intro Intermediate course
VBA and Multiple Excel Files
Is it possible to have the VBA code go into multiple excel workbooks that are not necessarily open and pull out values / data?
For upcoming training course dates see: Pricing & availability
RE: VBA and Multiple Excel Files
Hi Matthew
If you want to open a closed workbook from another workbook to then copy values from it you write the following code:
Application.Workbooks.Open "C:\My Documents\Accounts\2008 Accounts.xls"
The full path of the Workbook's address can be found using Windows Explorer and copied in. The path is a string.
The Workbooks.Open method also allows you to set other Worksheet values like passwords
Hope this helps
Carlos
Thu 16 Apr 2009: Automatically marked as resolved.
|