View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew B[_3_] Andrew B[_3_] is offline
external usenet poster
 
Posts: 7
Default 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