Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How Can I Move Excel Worksheets from within VFP?
Message
From
03/10/1998 15:08:14
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00143072
Message ID:
00143630
Views:
29
>>>oExcel.sheets(oVar.nSheetNumber).Move After:=Sheets(oVar.nSheetNumber-1)
>>
>>I don't know if this was a typo, but shouldn't it be
>>
>>>oExcel.sheets(oVar.nSheetNumber).Move After:=oExcel.Sheets(oVar.nSheetNumber-1)
>
>Thanks for writing!
>
>Well, the trouble that VFP is having is with the "After:" clause. Its syntax is foreign to VFP. So my question is about how to substitute this command line with something that VFP is more agreeable to.
>
>Michael Reynolds


The MoveAfter seems to be a method, though it seems to be assigned as a property (wrll, that's VB), so I guess this may do (unless a simple = instead := may do the trick)

oExcel.sheets(oVar.nSheetNumber).Move After(oExcel.Sheets(oVar.nSheetNumber-1))

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform