Copying Worksheet to Another Open Workbook
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.
|