View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 363
Default 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