Automation Error - Ideas?

[GMorris]

Hi, all,

I've tried searching for this and I'm not getting very far, so here goes:
Using Access 2000 to control Visio 5, I have no problem selecting a drawing
from a DB, and opening it. I'm using syntax "Set oDoc =
oVisio.Documents.Open(list1.Column(1))" to get a handle on the drawing, no
problem. When done, I am attempting to use "oDoc.Close", which seems
reasonable. It does indeed close the drawing, but immediately stops with
"Automation Error". At that point I have the options End or Debug, and
choosing Debug just takes me to the line with "oDoc.Close". I even tried
this with the Close statement directly following the Open statement, and it
does the same thing. Visio remains open, with no document until I close it
manually or use the Immediate pane to type the oVisio.Quit method. I have
tried everything I can think of, and I just cannot figure this one out. Any
ideas will be greatly appreciated!

 

[GMorris]

I found it, had to disable VBA in Visio. Strange quirk, to say the least!