Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Sheets
Message
From
30/04/2004 12:52:29
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00899822
Message ID:
00899836
Views:
18
Yuri,
Try passing .null. as before parameter
Cetin

>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!
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform