| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing a reference
Hi
I have Excel workbooks which reference an .xla file to access subroutines. I would like to change the name of the reference to an updated version. Is there any way I can do this programmatically through VBA, without having to manually open each workbook, go to the VBE and change the reference manually ? TIA Andrew Bourke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing text between hyphens and removing the hyphens | Excel Discussion (Misc queries) | |||
| Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Removing $$ Reference in cells | Excel Worksheet Functions | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
![Andrew B[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
