Forum Discussion
Pulling Data from one workbook to another
I know this question has been asked before but I'm very new to this so I'm having trouble following the lingo: I want to pull Data from a workbook with a contract on (with no set name as diff contr...
Ah okay, I took that out but it's still throwing up an error 438
How about
ThisWorkbook.Worksheets("Pull").Range("C11").Value = ActiveWorkbook.Worksheets("Page One").Range("C3").Value- I tried that earlier but it threw up an error 9. I think it might be the ThisWorkbook and ActiveWorkbook causing the issue but because the contract workbook won't have an identical name I don't know what to call it in the code
Which workbooks are open when you run the code?
Which one of them is the active workbook?
It might help if you posted more of the macro.
- That is the entire macro code which is probably where I'm going wrong, the two workbooks that would be open are: "Email Tool" and a contract that will have a different name each time but we can call "Contract" for the sake of this.
Started making this tool to learn how to macro as I have to learn by doing so apologies if I'm making basic mistakes.