I have been making some edits to a spreadsheet program that references some 32-bit dlls. I'm not the original developer but have taken over from him. These dlls provide a connection to other software and therefore I do not have the source code.
It runs fine on my client's Excel 2007 but not on the Excel 365 64 bit (15.0.4517.1004).
My best guess so far is that it is referencing the 32 bit dlls and therefore will not run on the 64 bit version of Excel.
If this is the case, then is there any way to make it work. I've been doing some reading about declare statements using PtrSafe and VBA7, but so far I do not see any Declare statements in the VBA module, it is just using the References.
Or would a better solution be to have the client install the 32 bit version of Office? Would this allow any earlier programming to function properly?
TIA, rasinc.
It runs fine on my client's Excel 2007 but not on the Excel 365 64 bit (15.0.4517.1004).
My best guess so far is that it is referencing the 32 bit dlls and therefore will not run on the 64 bit version of Excel.
If this is the case, then is there any way to make it work. I've been doing some reading about declare statements using PtrSafe and VBA7, but so far I do not see any Declare statements in the VBA module, it is just using the References.
Or would a better solution be to have the client install the 32 bit version of Office? Would this allow any earlier programming to function properly?
TIA, rasinc.
