Variable workbook name references
I want to copy values from my active workbook to a series of open, inactive
workbooks. I know this can be done by explicitly naming each destination
workbook:
Cells(1,1).Copy
Destination:=Workbooks(€śWkbk1.xls€ť).Sheets(€ś Name€ť).Range("A1")
In my application, I want to synthesize the workbook names as variables from
values in a master file and replace the workbook name €śWkbk.xls€ť with each
variable needed. If I try to just replace the name with a variable, I get a
€śSubscript out of range€ť error. How can I do this without having to activate
each workbook in turn?
--
Al C
|