View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Roger Whitehead[_2_] Roger Whitehead[_2_] is offline
external usenet poster
 
Posts: 28
Default VBA---Tools--References automatic

Watch for the word wrap -

With ThisWorkbook.VBProject.References
.AddFromFile ("C:\WINDOWS\SYSTEM\MSForms.TWD")
End with

'Cant be sure if that's the correct ref though...


--
---
HTH
Roger
Shaftesbury (UK)
(Excel 2003, Win XP/SP2)

"Denys" wrote in message
ps.com...
Good day everyone,

Is it possible through VBA in the Workbook open to add an instruction
in order to make sure that the "Microsoft Forms 2.0 Object Library" is
entered..

In the VBA window, you must click on Tools, then References and then
click on the "Microsoft Forms 2.0 Object Library"

I'd like this to be automated..... I tried:

Private Sub Workbook_Open()
VB(References("Microsoft Forms 2.0 Object Library")).Installed
= True

Does not work... Also played around with the paranthesis.... Did not
work either...

If someone knows, I would appreciate.

Thanks for your time

Denys