Excel: Copy Worksheet into another Workbook

Scripting Forums AppleScript | Mac OS X
#1

Hello scripting community,

I’m trying to figure out how to copy a worksheet from one workbook into another in Excel version 2004. I’ve tried something along the lines of (where WFLName is the name of the workbook I want to copy into, which is currently open):

copy worksheet (worksheet sheetname) after sheet (sheet 1 of workbook WFLName)

But it doesn’t work. It does copy the sheet, but it pastes it into a new workbook. Can anyone offer any help? I’ve been trying to get this to work for some time now.

Thanks a lot.

-Matt

#2

Uh… so I figured it out like 5 seconds after posting this. In case anyone else runs into a similar problem, I solved it by doing this:

copy worksheet (worksheet sheetname) after sheet 1 of workbook WFLName

Cheers!