Posted to microsoft.public.excel.programming

Dr.Schwartz Dr.Schwartz is offline

external usenet poster

Posts: 39

Remove reference from code

My VBA project has a reference to an xla - lets call it external.xla. Not all
users of my VBA project has this xla installed. Is there any way to check the
existence of the xla from my code when the VBA project is opened. If it exist
it is placed in the folder C:\xlaStore.

If the xla does not exist I would like to remove the reference or perhaps
just ignore it in some way.

Thanks
The Doctor

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove reference names	latha	Excel Programming	4	August 3rd 04 01:13 AM
Add Remove DLL reference in VB	Alex	Excel Programming	8	June 14th 04 01:34 PM
remove reference via code	Brian	Excel Programming	1	April 22nd 04 06:10 PM
Use VB code to remove code in sheet1	WashoeJeff	Excel Programming	4	January 25th 04 12:23 AM
Remove a reference	Niklas[_3_]	Excel Programming	8	November 11th 03 10:19 AM

All times are GMT +1. The time now is 06:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us