Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Syntax - copying one worksheet to another new one
Message
From
14/06/2001 05:14:58
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00518215
Message ID:
00519209
Views:
16
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform