Message 1 of 3
VB add-in versus VBA

Not applicable
05-19-2002
10:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I wrote a VBA Document Project routine to insert drawing borders and title
blocks. It worked fine. I wanted to create drop down menus to access it so I
redid it in VB as an add-in. It compiles fine, but when I try to run it, I
get an error unable to creat Active X component. This is caused by the
following lines:
Dim oDrawDoc As DrawingDocument
Set oDrawDoc = ThisApplication.ActiveDocument
Does anyone know what I am missing?
Thanks,
Joe
blocks. It worked fine. I wanted to create drop down menus to access it so I
redid it in VB as an add-in. It compiles fine, but when I try to run it, I
get an error unable to creat Active X component. This is caused by the
following lines:
Dim oDrawDoc As DrawingDocument
Set oDrawDoc = ThisApplication.ActiveDocument
Does anyone know what I am missing?
Thanks,
Joe