copying excel sheets using automation
Posted on 1999-01-14
i'm using automation to automate excel and do a few things automatically.. (isn't auto such a great word?) anyway, i'm trying to copy a worksheet from one workbook to another, but i can't figure out how.. documentation on this is pretty vague.. the program is actually an mfc based program, but to automate excel, i just created the excel classes from the excel type library..
i figure i need to use the worksheet::add function, BUT i don't understand the parameters if that's what i'm really supposed to use..