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