beginvbaanalyst
Board Regular
- Joined
- Jan 28, 2020
- Messages
- 141
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
Please help.
I'm wanting to open a closed workbook with a macro, then make the variable, then set the variable, then copy from a separate (already open) workbook and paste into the new set workbook. How do I do this correctly?
I keep getting this error.
My current vba is the following:
Please help.
I'm wanting to open a closed workbook with a macro, then make the variable, then set the variable, then copy from a separate (already open) workbook and paste into the new set workbook. How do I do this correctly?
I keep getting this error.
My current vba is the following:
VBA Code:
Sub OpenAddClubsScript()
Workbooks.Open Filename:="A:\Scripts Library\WSM3_Listing_Template_9.17.18.xlsx"
Dim ListScript As Workbook
'Prompt Sheet1[LIST]
'Workbooks("ListScript").Activate
Set ListScript = Sheets("LIST") 'set sheet for formula
'With LISTARTICLES.Range("A2", LISTARTICLES.Range("A" & Rows.Count).End(xlUp)).Copy LIST.Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub