C++ dll in Excel 97 does not work in Excel 2003

D

dd007007

Hi there, I am using a c++ dll in excel 97 and calling dll functions, and it
works just fine. Now, When I try to run the same dll/xls file with all VBA
code, macros it gives me error right at registering the dll at line
Range("1!A1") = "=REGISTER.ID(""Black"",""ef_fv"",""BIBBBBB"")":

Sub Auto_open()
Application.ScreenUpdating = False
Application.DisplayFullScreen = True
AddIns("Analysis Toolpak").Installed = True
Range("1!A1") = "=REGISTER.ID(""Black"",""ef_fv"",""BIBBBBB"")"
Range("1!A2") = "=REGISTER.ID(""Black"",""ef_delta"",""BIBBBBB"")"
Range("1!A3") = "=REGISTER.ID(""Black"",""ef_gamma"",""BIBBBBB"")"
Range("1!A4") = "=REGISTER.ID(""Black"",""ef_sp"",""BIBBBBB"")"
End Sub


I would really appreciate it if someone can help me in this.
 
Top