johnbongrovey
New Member
- Joined
- Apr 17, 2013
- Messages
- 8
I am trying to put the variable from a file open routin into the workbook statement:
I get the variable for filename:
workbooks.Open Filename:=FName
'Then I pass it to the subroutine which works fine. I would like to enter the Variable in multiple copy commands:
I am just lacking on the actual syntax of the command below
workbooks("Variable here (FName)").ActiveSheet.Range("C2:L2000").Copy
Any help would be appreciated
I get the variable for filename:
workbooks.Open Filename:=FName
'Then I pass it to the subroutine which works fine. I would like to enter the Variable in multiple copy commands:
I am just lacking on the actual syntax of the command below
workbooks("Variable here (FName)").ActiveSheet.Range("C2:L2000").Copy
Any help would be appreciated