Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Sheets
Message
 
To
30/04/2004 12:22:05
Jobert Tolentino
Transcontinental Direct
Etobicoke, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00899822
Message ID:
00899828
Views:
16
expression.Move(Before, After)

For unknown reason I was never able to use "after:" for Move, only "before:". It accepts only one parameter and treats it as "before:".

>Hello,
>
>I'm trying to automate the creation of a workbook by inserting specific sheets from different workbooks. There is a problem in the syntax of my move which I can't seem to pinpoint.
>
>
>My code:
>myExcel.Application.Workbooks(2).Sheets(1).Move ;
> After:=myExcel.Application.Workbooks(1).Sheets(1)
>
>Thanks in advance!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform