Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving an Excel worksheet
Message
 
To
18/05/2007 09:32:08
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01226679
Message ID:
01226720
Views:
24
>I am trying to move an Excel (2003) worksheet in a VFP9 program. The program opens the spreadsheet and populates values with no problem. When I use the Move method, I get an error telling me "Unable to get the Move property of the Worksheet class.". The specific statement is:
>
>oWorkbook.Sheets(1).Move(48)
>
>The same thing occurs with the oExcel.ActiveSheet.Move - whatever Move method I try. I'd appreciate some help! Thanks.

What do you want to move ? And if the worksheet, then what do you mean, 48
.Move(48) ?

The syntax is
.Sheets(1).Move(Before, After)

Like:
o.Sheets(2).Move(,o.Sheets(3))
Previous
Reply
Map
View

Click here to load this message in the networking platform