Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Create own function in EXCEL
Hello all,
My idea is to create own Excel-Function's with VBA to access to an VFP-COM-Server. Example for the VBA-Code is:
**************************************************************
* Create the object-reference to the COM-server
**************************************************************
Private Sub Workbook_open()
Set FIBU_funktionen.FIBU = CreateObject("fibuole.ex_sap")
End Sub
*********************************************************
Example for a own-excel-function in VBA
*********************************************************
Public Function get_fisaldo(lnKonto, _
lnJahr, _
lnMonat, _
lcGesb, _
lnKennzahl)
get_fisaldo = FIBU_funktionen.FIBU.loFunction.get_fisaldo( _
lnKonto, _
lnJahr, _
lnMonat, _
lcGesb, _
lnKennzahl)
End Function
The Com-Server calculatate the resultat and return one value. In this Example, i'm write in any cell: =get_fibusaldo(61000,2000,1,'0001',5) .
My Problem is:
Excel create automatic an assistent for the own function. This is wunderfull
for simple functions. How cann i'm manipulate this assistent ? My own functions have normaly many of parameters, and i'm will the user give an interface to set this (with combobox, etc) .
Where have an idea ?
Hendrick Kurland
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement