Posted to microsoft.public.excel.programming

Anson[_2_] Anson[_2_] is offline

external usenet poster

Posts: 28

GUID of the Reference

I am trying to write a macro to add a VB Project reference. By using

NewWorkbook.VBProject.References.AddfromGuid("Guid ","Major","Minor")

Now how can I find the the GUID, major and minor of the reference that I trying to add? By the way, I am trying to add "Microsoft Visual Basic for Applications Extensibility" and my version is Excel 97.

Thanks,

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
Create A GUID	Derek Hart	Excel Worksheet Functions	3	December 24th 07 01:30 AM
Error setting GUID reference	Amit Shanker	Excel Programming	7	May 16th 04 04:51 PM
Setting GUID reference error	Amit Shanker	Excel Programming	0	May 15th 04 02:33 PM
.dll and GUID	Ross[_7_]	Excel Programming	0	May 12th 04 03:56 PM
Possible to generate a GUID in Excel?	Dan[_29_]	Excel Programming	2	January 6th 04 06:30 AM

All times are GMT +1. The time now is 04:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us