General information
Category:
COM/DCOM and OLE Automation
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only