Personal.xls Save Dialog Box

M

Murtaza

Dear Experts:

I have created a function in VB6 & save the file as DLL, then save this file
in System directory. To call this function, created the following function
in Personal.xls:

Public Function FigureToWord(ByVal Number As Double) As String
Dim n As FigureToWord
Set n = New FigureToWord
n.CurrencyFractionPart = "Paisa"
n.CurrencyName = "Rupees"
FigureToWord = n.GetWord(Format(Number, "#.00"))
End Function

The above lines list my DLL in "Excel Function List (fx)"

Now whenever I close MS Excel, it always ask me to "Save Personal.xls and
says that if i dont save it now, i will lost the macros". This is very
irritating. Please help

If you need further information please ask.

Regards,
Murtaza
 
Top