Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get rid of VBA-reference??
I've been using a spreadsheet for quite a long time now, with VBA code I
wrote in modules functioning very well. Since recently code doesn't work anymore, because Excel searches for a missing object library. The reference is to a file PdfLib.TWD, which seems to belong to Adobe Reader 5.0. (I have updated from Adobe Reader 5.0 to 6.0, but the PdfLib.TWD file belonging to version 5 is still present in C:\Program Files\Adobe\Acrobat 5.0\Reader\ActiveX.) I tried to get rid of this reference by unchecking it, but this is impossible because Excel says that this library is still in use. I'm not aware of anything! However, there is a userform present in this workbook, just using some "ordinary" controls (command buttons, checkboxes, etc.; nothing "exotic"). I've even tried what happened when I deleted the userform. Excel still needed the reference. Could anyone help me out? Thanks in advance! Peter PS To make it even stranger (at least for me) the following. I'm still using Excel 97 under Windows XP SP2. This is at home. Ofcourse I tried the same in my office (Excel 2002 SP3): no problem whatsoever as to functioning of the code! The "strange" reference now showed as MISSING, but I still couldn't uncheck it! I then saved a copy of the file and tried it at home again: same problems as before. The only difference was that the path it was looking for had changed to the "office path" I had been using to save the file. And I still cannot delete the reference! What could be the solution tho all of this?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get rid of VBA-reference??
Try hitting the reset button, then try removing the reference.
If you can't remove it that way, you can remove it with code. Look at the references object in the VBA Extensions library. It has a remove method. -- Regards, Tom Ogilvy "Peter_A_M (NL)" wrote in message ... I've been using a spreadsheet for quite a long time now, with VBA code I wrote in modules functioning very well. Since recently code doesn't work anymore, because Excel searches for a missing object library. The reference is to a file PdfLib.TWD, which seems to belong to Adobe Reader 5.0. (I have updated from Adobe Reader 5.0 to 6.0, but the PdfLib.TWD file belonging to version 5 is still present in C:\Program Files\Adobe\Acrobat 5.0\Reader\ActiveX.) I tried to get rid of this reference by unchecking it, but this is impossible because Excel says that this library is still in use. I'm not aware of anything! However, there is a userform present in this workbook, just using some "ordinary" controls (command buttons, checkboxes, etc.; nothing "exotic"). I've even tried what happened when I deleted the userform. Excel still needed the reference. Could anyone help me out? Thanks in advance! Peter PS To make it even stranger (at least for me) the following. I'm still using Excel 97 under Windows XP SP2. This is at home. Ofcourse I tried the same in my office (Excel 2002 SP3): no problem whatsoever as to functioning of the code! The "strange" reference now showed as MISSING, but I still couldn't uncheck it! I then saved a copy of the file and tried it at home again: same problems as before. The only difference was that the path it was looking for had changed to the "office path" I had been using to save the file. And I still cannot delete the reference! What could be the solution tho all of this?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get rid of VBA-reference??
Thanks for your suggestions.
Hitting the Refresh button didn't work (I had tried that numerous times already!). The VBA approach you suggested, was in my mind also; I'll try it as soon I find the time! Thanks again, Peter "Tom Ogilvy" wrote: Try hitting the reset button, then try removing the reference. If you can't remove it that way, you can remove it with code. Look at the references object in the VBA Extensions library. It has a remove method. -- Regards, Tom Ogilvy "Peter_A_M (NL)" wrote in message ... I've been using a spreadsheet for quite a long time now, with VBA code I wrote in modules functioning very well. Since recently code doesn't work anymore, because Excel searches for a missing object library. The reference is to a file PdfLib.TWD, which seems to belong to Adobe Reader 5.0. (I have updated from Adobe Reader 5.0 to 6.0, but the PdfLib.TWD file belonging to version 5 is still present in C:\Program Files\Adobe\Acrobat 5.0\Reader\ActiveX.) I tried to get rid of this reference by unchecking it, but this is impossible because Excel says that this library is still in use. I'm not aware of anything! However, there is a userform present in this workbook, just using some "ordinary" controls (command buttons, checkboxes, etc.; nothing "exotic"). I've even tried what happened when I deleted the userform. Excel still needed the reference. Could anyone help me out? Thanks in advance! Peter PS To make it even stranger (at least for me) the following. I'm still using Excel 97 under Windows XP SP2. This is at home. Ofcourse I tried the same in my office (Excel 2002 SP3): no problem whatsoever as to functioning of the code! The "strange" reference now showed as MISSING, but I still couldn't uncheck it! I then saved a copy of the file and tried it at home again: same problems as before. The only difference was that the path it was looking for had changed to the "office path" I had been using to save the file. And I still cannot delete the reference! What could be the solution tho all of this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |