ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   C++ dll in Excel 97 does not work in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/25038-c-dll-excel-97-does-not-work-excel-2003-a.html)

dd007007

C++ dll in Excel 97 does not work in Excel 2003
 
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.


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com