Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default List of GUIDs and other properties for future references

Hi,

It's possible to get information on checked references (in
Tools/References) such as name, GUID, Major, Minor, etc., but I am
looking for some code that will list that information on unchecked
references.

Thanks/Cheers.

Marc R. Bertrand
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default List of GUIDs and other properties for future references

Marc,

I don't believe it is possible to get any information about the unchecked
items in the references dialog.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Marc R. Bertrand" wrote in message
om...
Hi,

It's possible to get information on checked references (in
Tools/References) such as name, GUID, Major, Minor, etc., but I am
looking for some code that will list that information on unchecked
references.

Thanks/Cheers.

Marc R. Bertrand



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default List of GUIDs and other properties for future references

I just thought that exporting the registry to a text file and
searching in HKEY_CLASSES_ROOT\TypeLib\ for the proper strings ({}
etc.) with some loop could produce the info I want.

Marc R. Bertrand


(Marc R. Bertrand) wrote in message . com...
Hi,

It's possible to get information on checked references (in
Tools/References) such as name, GUID, Major, Minor, etc., but I am
looking for some code that will list that information on unchecked
references.

Thanks/Cheers.

Marc R. Bertrand

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
Programmatically finding 2007 Excel and other Office GUIDs Ted Setting up and Configuration of Excel 1 December 30th 08 10:44 AM
Find closest future date from list ... Ray Excel Discussion (Misc queries) 3 September 20th 07 07:43 PM
GUIDs copied from Access display illegibly in Excel 2003 sebh007 Setting up and Configuration of Excel 0 March 22nd 07 03:26 PM
validation/list properties Myriam Excel Worksheet Functions 1 January 18th 06 02:07 PM
Rogue Password on Properties and References ExcelMonkey Excel Discussion (Misc queries) 0 October 5th 05 01:16 PM


All times are GMT +1. The time now is 09:39 AM.

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"