April 5th, 2005, 4:46 am
Hi, I am using VC++.Net now. After selecting EXCEL.EXE as the excutable file and press F5, there is an error message:No symbolic Information'EXCEL.EXE' does not contain debugging information. (No symbols loaded) Click OK to debug anyway. If I click OK, it will generate a new workbook for me. My knowledge about VC.Net is limited. Currently I wanna code in C++ and call dll from VBA.My code in VC++:EXTERN_C void WINAPI MyFunction (LPSAFEARRAY* Array1, LPSAFEARRAY* Array2, double a, double &output ) { ... }Function declared in VBA:Declare Sub MyFunction Lib "MyPath\Debug\MyProject.dll" _ (array1(), array2(), ByVal a As Double, ByRef output As Double)I have built the solution, so I can find "MyProject.dll" under "Debug" folder. But I can't run MyFunction in VBA and can't debug it through VBA. Any guidance?Chris