Forum Discussion

Elcten's avatar
Elcten
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's avatar
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's avatar
    Elcten
    Copper Contributor
    Mar 21, 2022
    Ah okay, I took that out but it's still throwing up an error 438
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 21, 2022

      Elcten 

      How about

       

      ThisWorkbook.Worksheets("Pull").Range("C11").Value = ActiveWorkbook.Worksheets("Page One").Range("C3").Value
      • Elcten's avatar
        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

Resources