Seamus2626
asked on
referencing a workbook VBA
I have a module
Sub RunTheReport()
Dim Repfile As Workbook
Set Repfile = ThisWorkbook
Application.ScreenUpdating = False
Call XYZ
End Sub
with in XYZ, I have a line of code saying
RepFile.activate
I am getting the "object Required" error
Where am i going wrong?
Thanks
Sub RunTheReport()
Dim Repfile As Workbook
Set Repfile = ThisWorkbook
Application.ScreenUpdating
Call XYZ
End Sub
with in XYZ, I have a line of code saying
RepFile.activate
I am getting the "object Required" error
Where am i going wrong?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.