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".
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".
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".
asVariantNull() is not available in VEE 5.x, I believe.
Regards,
Scott Bayes
Software Technical Support
Agilent Technologies, Inc.
815 14th Street S.W.
Loveland, CO, U.S.A. 80537
970 679 3799 Tel
970 635 6867 Fax
> -----Original Message-----
> From: Georg Nied [mailto:g.nied@gn-software.de]
> Sent: Wednesday, August 13, 2003 2:18 AM
> To: VEE vrf
> Subject: [vrf] RE: ActiveX Excel Worksheet.Move(After)
>
>
> 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: scott_bayes@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".
>
---
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".