Hi I am trying to create a macro that copies data from a workbook and then pastes special and adds the data to cells in the current workbook. Also I'd like it to close the workbook that the macro opens once it has done the copying.
My code so far is as follows but It does not really work. Please help ASAP.
Please Login or Register to view this content.
Last edited by jigypeper; 08-03-2012 at 05:19 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
Last edited by arlu1201; 08-02-2012 at 06:39 AM.
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]
What is the error you are getting?
Try this code
Please Login or Register to view this content.
Thanks but I managed to solve the problem last night. Just needed to define the seperate workbooks and tell it which one to activate and when.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks