I am having a little trouble figuring out the syntax for coping and pasting between different workbooks. Can anyone show me how to write the syntax for this?
This is what I have so far, it is not finished so obviously won't work.
Please Login or Register to view this content.
Last edited by JapanDave; 08-31-2011 at 09:12 AM.
Is this macro going to reside IN the data workbook?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
I would expect something along the lines of:
Please Login or Register to view this content.
But if only values are your concern, this will suffice:
Please Login or Register to view this content.
Thanks Jerry and SNB, that helps me immensly in understanding this syntax.
Jerry, it is actually the other way around, "Newbook" was just a reference for me to make thing easier to understand when writing the code. The Data workbook is the book I receive each month with new data in it. Newbook is where the code will reside.
I modified your code Jerry to select a range, is this the best way to do it? or is there a better way to select a group of cells?
Also , as an after thought , there is a possibility in the future that the Data I am receiving will have a dynamic number of rows.Please Login or Register to view this content.
I was made this code, but it is not working. I get an error?
Please Login or Register to view this content.
Last edited by JapanDave; 08-30-2011 at 09:29 AM.
In that case:
Please Login or Register to view this content.
Thanks SNB, but I can't seem to get this code to work, it runs through with no errors, so I am not sure what is wrong. I will check my workbook names and worksheet names to make sure I have not made any typos.
Hi JapanDave. Be sure to indicate in new lines of code which sheet it is to apply to.
Please Login or Register to view this content.
Thanks Jerry for the explanation.
Going back to your earlier code,
I can't seem to manipulate this code to work in the "NewBook" workbook, it will reside in the "NewBook" , not the "Data" workbook. Sorry for the confusion.Please Login or Register to view this content.
Hey SNB,
Could you help me understand this line?
At the moment it is selecting only Row1 ,Column1. How would you adjust the code to select multiple columns and start the copy in Row3?Please Login or Register to view this content.
Sorry for all the questions guys, but you don't know how much this is helping me understand different aspects of VBA.
Please Login or Register to view this content.
If you make sure column A doesn't contain empty cells, the code will do it's job.
Since you didn't provide a sample worksheet it's rather guessing....
but if you want to 'copy' the whole worksheet to cells(3,3) ("C3")
Please Login or Register to view this content.
Last edited by snb; 08-31-2011 at 03:52 AM.
@Jerry, Thanks for that, I was leaving out the "xls" part and that is where I was going wrong.
@SNB, I can post an example for you to take a look at, but it is at work. I will try and get it uploaded tomorrow. BTW, the first column has no blank cells and it does select the whole first column which has about 3000 rows, but I wondering how I would be able to have select columns out to say the 20th column on the source sheet, assuming that there are no blanks cells in any of the columns?
To 'copy' the 20th column in sheet 'Record' in workbook 'Data' to the 3rd column in sheet 'Report' in workbook 'Newbook':
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks