Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling MS Excel from VFP 6.0
Message
De
21/10/1998 15:46:28
 
 
À
21/10/1998 15:24:31
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00149051
Message ID:
00149074
Vues:
34
Jim ---

oExcel=CREATEOBJECT("Excel.Application")
oExcel.Workbooks.Open("c:\My Documents\MyWorksheet.XLS")
oExcel.Visible=.T.


>I need to open excel with a specific worksheet.
>
>>AppShow is not valid for Excel. I can't pull up my VB Help for Word....what exactly are you trying to do?
>>
>>
>>>I had an example that does this with word, so I figured excel would be done the same way. Is this not correct?
>>>
>>>
>>>>Jim ----
>>>>
>>>>What the heck is "AppShow"?
>>>>
>>>>
>>>>>I am trying to run Excel from VFP 6.0. Here is the code I am using, this doesn't seem to work. Any ideas??
>>>>>
>>>>>oExcel = CREATEOBJECT("excel.application")
>>>>>IF TYPE ("oExcel") # "O" OR ISNULL(oExcel)
>>>>> =MESSAGEBOX("Please make sure that excel is install on this machine.",16,"test")
>>>>> RETURN
>>>>>ELSE
>>>>> oExcel.AppShow()
>>>>>ENDIF
>>>>>
>>>>>
>>>>>Thanks
>>>>>
>>>>>Jim
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform