Switching between two workbooks
I am a newbie trying to sort out some code. The code I cuurently have (below) works, but now I want to add to it and go back to the JnlReg workbook paste some information there from Thisfile and then save and close JnlReg.
Thanks in advance
Please Login or Register to view this content.
Just create another variable to hold the opened file and assign it when you open it:
Please Login or Register to view this content.
You can then refer to it as required.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you, worked a treat
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks