Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving a spreadsheet using Automation
Message
 
À
04/11/2004 16:52:42
Tim Muller
Innovative Solutions, Inc.
West New York, New Jersey, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00958188
Message ID:
00958428
Vues:
16
I'm not 100% sure. But I noticed in Excel Automation that if you are trying to interact with a lower level (down to the work sheet for exemple), that it works better to go to that lower level, rather than trying to work it "from above". Sorry I don't have a better explanation, other "This technique seems to work".


>Mike--
>
>>Try referencing the workbook itself to see if it solves your problem
>>
>>
o = GETOBJECT(,'excel.application')
>>owb = o.ActiveWorkbook
>>owb.saveas(("c:\SamSludge.txt")
>>
>
>Your code worked (an extra left paren though). Can you explain why your code worked and my code
>
> o.ActiveWorkbook.SaveAs ("c:\SamSludge.txt")
>
>did not work?
>
>
>Thanks.
>
>
>Tim
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform