Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Naz Naz is offline
external usenet poster
 
Posts: 85
Default Access library

Hello,

I have a macro that uses the Microsoft Access Object library.
But in order to run the macro the library has to be installed (checked in
reference) otherwise it will not work.
Is there any way to create a macro that when the spreadsheet opens
automatically installs the library so that anyone can use the macro.

All help is appreciated.
--

_______________________
Naz,
London
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Access library

Hi Naz

You can use Late binding
Here is a example for Outlook
http://www.dicks-clicks.com/excel/olBinding.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Naz" wrote in message ...
Hello,

I have a macro that uses the Microsoft Access Object library.
But in order to run the macro the library has to be installed (checked in
reference) otherwise it will not work.
Is there any way to create a macro that when the spreadsheet opens
automatically installs the library so that anyone can use the macro.

All help is appreciated.
--

_______________________
Naz,
London



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Using C++ Dll library No Name Excel Programming 2 October 28th 04 05:22 PM
Reference Library - Missing Library in a lower version. luvgreen Excel Programming 1 October 7th 04 02:08 AM
References to ADO library for ACCESS connection Brian C[_2_] Excel Programming 2 April 26th 04 01:23 PM
Use the .NET Library in VBA? Thomas Wieser Excel Programming 1 April 14th 04 02:07 PM
access the solver reference library CAB[_2_] Excel Programming 2 December 15th 03 07:30 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"