View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default How to create a Reference with VBA

When you are assigning the reference do you have to reference the Major and
Minor??

Reflections for IBM version 8:
{ECF246D9-E871-11D2-8CC2-00C04F72C0ED},8,0

Reflections for IBM version 11:
{ECF246D9-E871-11D2-8CC2-00C04F72C0ED},11,0

If I send a sheet with VBA without referencing the Reflections for IBM
Session... will I have to test the GUID major and minor to see which they
have before assigning it... or could I just add the reference with the GUID
itself?


"Tom Ogilvy" wrote:

Posting under the name Newbie? Assume you received your answer from Bart.

--
Regards,
Tom Ogilvy

"Gérard Ducouret" wrote in message
...
Tom,
It works fine! but i have 2 other questions :
- Is the syntaxe the same for Microsoft Word 9.0 and for Microsoft Word
11.0 (2000 and 2003)?
- How to remove this Reference ?
Thanks

Gérard

"Tom Ogilvy" a écrit dans le message
de ...
for word it would be:

Dim s as String
s = "{00020905-0000-0000-C000-000000000046}"

Thisworkbook.VBProject.References.AddFromGuid s,0,0

--
Regards,
Tom Ogilvy


"Gérard Ducouret" wrote:

Hello,

How can I create a Reference (Such as Tools / Reference in a VBA

module)
to
Microsoft Word 9.0 or to Microsoft Word 11.0, with VBA, then remove

the
reference at the end of the procedure?
Thanks ahead!

Gérard