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.