Switch from Active Window to Variable Window/Rename Varaible Sheet

FYI, my experience with macros is copying and pasting code from someone with a similar problem and then slightly modifying it for my own needs. I may not get all the lingo you throw at me.

I work with a program that creates an Excel file. It inputs data and creates a worksheet named after the file itself (the variable). The following code is part of a larger macro, but the code below is supposed to open a specific file, copy and paste the a range in a new sheet (named Sheet1), rename "Sheet1" to "Sheet2", and then rename the variable sheet to "Sheet1."

I'm having problems switching from the active window to the variable window and I can predict that I will have the same issues when renaming the variable sheet.

Thanks in advance.

Please Login or Register  to view this content.

"I'm not quite clear where you are copying from, and to...

You start with Workbook1 open, which contains your code.
You want to:
- open Workbook2
- copy some values from the existing worksheet in Workbook2 (which has a variable name), to a new sheet in Workbook2
- rename both worksheets in Workbook2
- close Workbook2

Is that correct? "

Code is currently stored in a personal workbook...different issue for a different day.

Workbook1 has the variable name and worksheet. Workbook2 is opened,copied, and pasted into Workbook1. Sheet pasted into WB1 to be renamed "Sheet2." Variable worksheet to be named "Sheet1."

Originally Posted by Olly

Sorry, still not entirely clear. Do you start with Workbook1 open, and the 'variable' sheet active?

If that IS the case, then try something like this:

Please Login or Register  to view this content.

If it is NOT the case that the 'variable' worksheet is the active sheet - then how are you identifying the 'Workbook1' workbook / worksheet?

Thanks, Olly

After using your code and slightly modifiying some other code I didn't provide earlier, I was able to get it working. A+, buddy.