AnsweredAssumed Answered

vrf ActiveX Excel Worksheet.Move(After)

Question asked by g.nied on Aug 15, 2003
Steve,

you try to move an excel sheet with the function
  sheet.move([before],[after])

the [] brackets indicate that the argument is optional but to leave out a
leading argument is not possible from vee. You can use s.move(sheet(1)) to
move sheet s before the first sheet but you cannot use s.move(,sheet(1)) to
move s behind the first one. One solution would be to implement your need
inside a VBA macro and call that macro from vee or to build a workaround.
In case you just want to insert a specific amount of worksheets and rename
them in a specific way you may act in two steps: first insert as many sheets
as you need. Next loop over each sheet and rename it.
You can use a 'for count' loop with a control input for the 'count'. Feet
the formula result of '...worksheets.count()' (=N) to the control input.
That loops from i=0 to N-1. Then feed the output to the formula
'...worksheets(i+1).name='Datasheet "+(i+1)' to rename them.

Hope that helps,


best regards,

G. Nied

-------------------------------------------------------------------------
Georg Nied  - Software-Development - Hansestr.7 - 51149 Cologne - Germany
Tel: +49 2203 9770915 - Fax: +49 2203 9770924 - eMail:info@gn-software.de
-------------------------------------------------------------------------


---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes