Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Syntax - copying one worksheet to another new one
Message
De
14/06/2001 05:14:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00518215
Message ID:
00519209
Vues:
17
This message has been marked as the solution to the initial question of the thread.
Ashley,
Maybe you didn't see the message I've addressed to Tamar but here's why you still get a syntax error:
Message #518403

HTH

>Hi again Tamar,
>
>Further to my previous message, sheets placed before the copied sheet can be renamed as a workaround..
>Just curious as to why I could not execute your code to place the sheets after.
>
>Tks
>
>>Right! I was confusing it with a similar WorkSheets method.. Sorry.
>>
>>However, even without the 3rd parameter I get a Syntax error from VFP. If I remove the comma in the Copy(,.sheets[1]) I get the expected results (the sheets are created before the copied sheet.
>>
>>
>>>>Using your example, Tamar, I also added the optional Count parameter to create nPages -1 copies of Page 1. Now I get a syntax error at that line...
>>>
>>>> ***********************************************
>>>> .Sheets("Page 01").Copy(,.Sheets[1],nPages-1)
>>>> ***********************************************
>>>
>>>I don't see an optional Count parameter for Copy. The syntax I'm seeing for the Copy method has only the two parameters I mentioned - Before and After - and you can only pass one of them.
>>>
>>>Tamar
Daniel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform