LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default VB code to set VBA References

I want to create a set of VB statements that will set the object references
required for my VBA code, such as, for the following,

Visual basic for applications
Microsoft Excel 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
Microsoft Project 11.0 Object Library
Microsoft ActiveX Data Objects 2.8 Library
Microsoft ActiveX Data Objects Recordset 2.7 Library

Have them compiled to .exe and then call it at the start of my VBA code.

This is to create the references without the user having to do it themselves.

I suppose it would be necessary to check whether the refernces are already
set, if so then skip this step.

Can someone please show me a few lines of, how to do this.

Thanks,
--
Sajit

 
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
Cell references in excel vba code Isis[_2_] Excel Discussion (Misc queries) 4 April 26th 10 01:10 PM
Help with VBA code - passing references to sheets? Rayo K Excel Programming 7 April 20th 06 06:51 PM
Line of Code to set references Myles[_60_] Excel Programming 5 April 7th 06 05:15 AM
Code that references the name of a cell pwrichcreek Excel Programming 8 February 6th 06 09:05 PM
Code to change references Steve[_27_] Excel Programming 0 August 4th 03 11:43 PM


All times are GMT +1. The time now is 04:13 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"