Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving an Excel worksheet
Message
 
À
18/05/2007 09:32:08
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01226679
Message ID:
01226720
Vues:
21
>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))
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform