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

Removing a reference
 

See Chip Pearson's page for working with the VBE

http://www.cpearson.com/excel/vbe.htm

There is a references collection for each project (workbook).

--
Regards,
Tom Ogilvy


"Andrew B" wrote in message
...
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