Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference path goes to lower case
I developed an Excel application where the worksheets reference DLLs that I
wrote. It is several versions old, and all DLLs are compiled with binary compatibility to the previous version. All DLLs have always worked on all user machines. Now, they still work on mine, but on user machines after the install of the new version, the references dialog indicates that the DLL is missing. When that is unchecked, closed, reopened, the DLL found & checked, the path is lower case. When the file is saved, closed & reopened, the DLL shows again as missing. Just before this version was installed, all machines were upgraded to Office 2003 sp2 and to XP sp2. There's probably a catch here somewhere. Any ideas? Thanks in advance - Stoney |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference path goes to lower case
after the install of the new version
Does that include registration (regsvr32) .. Regards, Peter T "Stoney" wrote in message ... I developed an Excel application where the worksheets reference DLLs that I wrote. It is several versions old, and all DLLs are compiled with binary compatibility to the previous version. All DLLs have always worked on all user machines. Now, they still work on mine, but on user machines after the install of the new version, the references dialog indicates that the DLL is missing. When that is unchecked, closed, reopened, the DLL found & checked, the path is lower case. When the file is saved, closed & reopened, the DLL shows again as missing. Just before this version was installed, all machines were upgraded to Office 2003 sp2 and to XP sp2. There's probably a catch here somewhere. Any ideas? Thanks in advance - Stoney |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference path goes to lower case
Absolutely. with first an Un-regsvr32, then a regsvr32.
Stoney "Peter T" wrote: after the install of the new version Does that include registration (regsvr32) .. Regards, Peter T "Stoney" wrote in message ... I developed an Excel application where the worksheets reference DLLs that I wrote. It is several versions old, and all DLLs are compiled with binary compatibility to the previous version. All DLLs have always worked on all user machines. Now, they still work on mine, but on user machines after the install of the new version, the references dialog indicates that the DLL is missing. When that is unchecked, closed, reopened, the DLL found & checked, the path is lower case. When the file is saved, closed & reopened, the DLL shows again as missing. Just before this version was installed, all machines were upgraded to Office 2003 sp2 and to XP sp2. There's probably a catch here somewhere. Any ideas? Thanks in advance - Stoney |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA reference path goes to lower case
I don't know! also not sure if change of case is directly relevant.
Absolutely sure compatibility was never broken ? Does the dll have any references to Office App's, eg Excel, if so was the dll compiled with these set to the oldest *.olb that any user might have. The Windows & Office upgrade, anything different about relative path's particularly as regards multiple users if different from the previous setup. Guess none of the above not related, maybe doing the following might lead somewhere - Temporarily register the old dll on your machine (same version that previously worked on user's system). Make an xls (file1) with a ref set to the old dll. Include some code to test all the exposed methods in the old dll. copy file1 to file2 Re-register the new dll remove the ref in file2 and set a ref to the new dll. Check file1 & file2 both work on your machine with file1 now using the new dll (but don't save file1 with the new dll registered) Send both files to your users to test with the new dll registered on their machine. Regards, Peter T "Stoney" wrote in message ... Absolutely. with first an Un-regsvr32, then a regsvr32. Stoney "Peter T" wrote: after the install of the new version Does that include registration (regsvr32) .. Regards, Peter T "Stoney" wrote in message ... I developed an Excel application where the worksheets reference DLLs that I wrote. It is several versions old, and all DLLs are compiled with binary compatibility to the previous version. All DLLs have always worked on all user machines. Now, they still work on mine, but on user machines after the install of the new version, the references dialog indicates that the DLL is missing. When that is unchecked, closed, reopened, the DLL found & checked, the path is lower case. When the file is saved, closed & reopened, the DLL shows again as missing. Just before this version was installed, all machines were upgraded to Office 2003 sp2 and to XP sp2. There's probably a catch here somewhere. Any ideas? Thanks in advance - Stoney |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Formula to identify lower case vs upper case | Excel Worksheet Functions | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |