EXCEL 2003 - IDE
Hello,
on my computer I work with EXCEL 2003. The installed operating system is Windows XP Pro. Now I have a question concerning the IDE. When I start the editor for visual basic appliction then I get access to a dialog box that enables me to add objects (DLL, TLB .... ) to EXCEL. My EXCEL is in German, but in English the name of the menu should be =tools =references ... Within the appearing dialog box I can check available references and add external references to the list of references. It is very easy to add a new reference. However, how do I delete a reference? I appreciate any help and would like to say thank you in advance! Best regards, Christian Lehmann |
EXCEL 2003 - IDE
Christian,
You cannot delete a reference, all you can do is to uncheck it and make it not available to the project. It doesn't create any overhead, all that will remain is that Excel knows where that library is stored should you restate it. -- HTH RP (remove nothere from the email address if mailing direct) "Christian Lehmann" wrote in message ... Hello, on my computer I work with EXCEL 2003. The installed operating system is Windows XP Pro. Now I have a question concerning the IDE. When I start the editor for visual basic appliction then I get access to a dialog box that enables me to add objects (DLL, TLB .... ) to EXCEL. My EXCEL is in German, but in English the name of the menu should be =tools =references ... Within the appearing dialog box I can check available references and add external references to the list of references. It is very easy to add a new reference. However, how do I delete a reference? I appreciate any help and would like to say thank you in advance! Best regards, Christian Lehmann |
EXCEL 2003 - IDE
Thank you for your respoonse! But how can I solve the following problem:
the path to the object (in this case a TLB-file) has changed (it was a network path). So if I still want to use all makros that need this TLB-file I have to update the reference. Is there any other way to do this but setting up my computer again? Thank you for any help! Christian |
All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com