Probably a silly vb6/Excel question
Greetings all; Ive been using the Excel 9.0 Object with VB6, and so far so good except that I cant seem to get the right syntax for copying a sheet inside of a workbook. If I use the copy methjod I get a new workbook created with a copy of the desired sheet in it. If I try to populate the Before, After parameters of the sheet copy method, I end up with Unsupported Property or Copy Method Failed Errors. Can anyone help me with this seemingly simple problem?
Thanks
Henry Loos
Greetings all; Ive been using the Excel 9.0 Object with VB6, and so far so good except that I cant seem to get the right syntax for copying a sheet inside of a workbook. If I use the copy methjod I get a new workbook created with a copy of the desired sheet in it. If I try to populate the Before, After parameters of the sheet copy method, I end up with Unsupported Property or Copy Method Failed Errors. Can anyone help me with this seemingly simple problem?
Thanks
Henry Loos