Topic: copy an excel sheet in vlisp?

[Amsterdammed]

Hello there,

i have a xls file with a standard sheet in it, i need to copy this and rename it and fill the fields with vlisp. the filling part i have covered, i found some code from fatty to add a sheet on the web but nothing to copy an existing one.

there was

Code: [Select]

(vlax-invoke-method
 xlSheets "Add" nil nil nil)used, so what be the methode to copy?

anybody any idea?

[BlackBox]

Have you considered the Copy Method?

[Amsterdammed]

i did, but i don't know the parameters for that

[Amsterdammed]

sorry,
obviously i suffer from a slow mental day. Got it

Code: [Select]

(vlax-invoke-method
 xlSheets 'copy  nil xlLastSheet   )


Thanks

[BlackBox]

sorry,
obviously i suffer from a slow mental day. Got it

Hey... No worries; I'm just getting a chance to check back... Glad you got it sorted.