I am using the sub below to copy a set of cell values to worksheet "Klantenbestand" in the same workbook. However, I want to store worksheet "Klantenbestand" in a separate workbook. Is it possible to change the sub so that it saves the cell values to worksheet "Klantenbestand" in for instance "book2.xlsm"?
I've got a hunch that a slight change in Sheets() should be the solution...
Please Login or Register to view this content.
Is book2.xlsm a new workbook that the macro needs to create or is it an already existing workbook?
Also, if its already existing, will it be open or should the macro open it?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks