Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet named "Temp" that resides in a Workbook called
"BaseFile.xls". I'm trying to copy it to another workbook whose name I have stored in a string fStr. Here's what I have: Windows("BaseFile.xls").Activate Sheets("Temp").Copy After:=Workbooks(fStr).Sheets(1) But I'm getting a subscript out of range problem with fStr in Workbooks.... Could someone tell me what the correct code should be. Most appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying worksheet to another workbook | Excel Worksheet Functions | |||
Copying a worksheet into the same workbook | New Users to Excel | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
Copying worksheet from workbook to another | Excel Worksheet Functions | |||
Copying worksheet to another workbook | Excel Programming |