copy a worksheet in Excell through Forms OLE2

[kashv]

Hello!
Please, could you put an example of copying worksheets inside an workbook using prefixes 'After' and 'Before'.
Is it possible to assign a template for the worksheet?

 

[sfvb]

Please, could you put an example of copying worksheets inside an workbook using prefixes 'After' and 'Before'.

Could you explain what you mean by After/Before prefixes?

 

[kashv]

Hello!
I was not accurate, I meant the syntax of Excel's method Worksheets.Copy:


Syntax 3: Copies the sheet to another location in the workbook.
expression.Copy(Before, After)

Before Syntax 3: Optional Variant. The sheet before which the copied sheet will be placed. You cannot specify Before if you specify After.

After Optional Variant. The sheet after which the copied sheet will be placed. You cannot specify After if you specify Before.

'Copy' without the variant does copy into new workbook.

 

[sfvb]

I finally had a chance to try this. I was unable to get this to work. I didn't get any errors, but it didn't do what it was supposed to do, either.