Can you have a macro in one workbook open another workbook?
Can you have a macro in one workbook open another workbook?
Yes, using a line of code like...
orPlease Login or Register to view this content.
for a new one.Please Login or Register to view this content.
Martin
Hello billykiller05,
Yes.
Please Login or Register to view this content.
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 Star below 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, I do it all the time.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Those worked great. One more thing I have the code written to copy from a static file name and location however I need the paste to be in a workbook that the filename is not static. How can I set the paste workbook to look at the filename?
I need the TestM to be whatever the user has named the file they are using.
Columns("A:K").Select
Selection.Copy
Windows("TestM").Activate
Range("A1").Select
Selection.PasteSpecial
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks