Syntaxt for WorkBook variable

[johnbongrovey]

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

 

[ClimoC]

Sorry - don't quite understand what you're saying... almost looks like you just want to store the Workbook as a variable?

Dim WB1 as Workbook
Set WB1 = Workbooks.Open(Filename:=FName)

WB1.Activesheet.range.. (etc).

 

[johnbongrovey]

I am trying to use a variable foir filename.
Basically I open a file and pull data from it and paste to 2nd file/worksheet. At this time I use a physical filename for both but I want ("filetest.xlsm") to be a variable, see below:
workbooks("filetest.xlsm").ActiveSheet.Range("C2:L2000").Copy
workbooks("FR Gathering.xlsm").Worksheets("sheet1").Range("C2:L2000").PasteSpecial xlPasteValues

 

[ClimoC]

I am trying to use a variable foir filename.
Basically I open a file and pull data from it and paste to 2nd file/worksheet. At this time I use a physical filename for both but I want ("filetest.xlsm") to be a variable, see below:
workbooks("filetest.xlsm").ActiveSheet.Range("C2:L2000").Copy
workbooks("FR Gathering.xlsm").Worksheets("sheet1").Range("C2:L2000").PasteSpecial xlPasteValues

Yeah - so do exactly what I said...

You can store the Workbook.Name property as a String and then

Workbooks(MyWBNameString).activesheet...

But in general, that'd be bad practice, because it has to evaluate what workbook that is each time. Also if any saving/name changing occured, it won't recognise it. Setting the Workbook Object to a variable is not only more commonplace, but it's safer

 

[johnbongrovey]

Thanks for all your help, all works good and everyone is happy