Forum Discussion

Copper Contributor

Mar 21, 2022

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...

Macros and VBA

office 365

HansVogelaar

MVP

Mar 21, 2022

Elcten

You don't need the .Value:

ActiveWorkbook.Worksheets("Page One").Range("C3").Copy _
    ThisWorkbook.Worksheets("Pull").Range("C11")

Elcten

Copper Contributor

Mar 21, 2022

Ah okay, I took that out but it's still throwing up an error 438

HansVogelaar
MVP
Mar 21, 2022
Elcten

How about

ThisWorkbook.Worksheets("Pull").Range("C11").Value = ActiveWorkbook.Worksheets("Page One").Range("C3").Value
- Elcten
  Copper Contributor
  Mar 22, 2022
  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
  - HansVogelaar
    MVP
    Mar 22, 2022
    Elcten
    
    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.