Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling functions in excel modules
Message
 
À
20/11/2003 15:45:15
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00852064
Message ID:
00852074
Vues:
9
This message has been marked as the solution to the initial question of the thread.
Try:
objExcel.Application.Run("MyFunc")

>Hi all,
>
>I have an Excel file with a Module containing a function, say: Public Function MyFunc(). How do I call this from VFP if at all possible. I don't have a problem calling the function from within Excel.
>
>Assuming oXLS is my excel object, so far these does not run:
>
>oXLS.Modules(1).MyFunc()
>oXLS.Workbooks.Modules(1).MyFunc()
>oXLS.Module1.MyFunc()
>oXLS.MyFunc()
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform