VBA Select open workbook

[JoeJackson12]

Hi, I'm having an extremely frustrating time just selecting on open workbook to copy and paste information.

The workbook I want to select is the workbook running the macro - the macro opens other workbooks, copies data from those workbooks, and pastes into cells in the workbook running the macro. I'm trying to use

Workbooks("macroworkbook.xlsm")

, but that's not working. Any advice would be much appreciated, as this seems like an easy problem that I'm having trouble solving!

 

[John_w]

The built-in object named ThisWorkbook is the workbook running the macro. ThisWorkbook is a Workbook object and you can reference a specific sheet and cell in it like this:

ThisWorkbook.Worksheets("sheetName").Range("A1")

 

[JoeJackson12]

Works perfectly. Thanks!