Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can't activate visio macros

28 views
Skip to first unread message

Mikas

unread,
Aug 12, 2002, 4:34:40 AM8/12/02
to
Hello,i need help,
problem:
I have hyperlink in excel to visio file.
And macros in visio

Private Sub Document_DocumentOpened(ByVal doc As IVDocument
Call Main )
End Sub

dont work.But if i open visio file in other ways,everythink works excelent.Why?
Please help


Sorry for my english
Audrius

Pete

unread,
Aug 12, 2002, 3:47:36 PM8/12/02
to
It might be because the Document_DocumentCreated event is being
thrown, not the DocumentOpened. I get better results putting my
startup code in the Document_RunModeEntered event handler. Whether a
document is created or just opened, it will go into Run mode
regardless.

Pete

Arun

unread,
Aug 16, 2002, 10:07:56 AM8/16/02
to

I have the same trouble, i have a macro function in VBA
which i want to load and be executed automatically when i
open the visio file. but i have it as both DocumentOpened
and also as DocumentCreated like you have suggested, but
its just not working and the function is not being invoked
at all. to test if its invoked, i am throwing an error pop-
up using Err.Raise function, but nothing seems to be
getting executed when i open the visio file. pls tell me
if i am missing something here.

>.
>

Reinier Post

unread,
Aug 29, 2002, 5:49:42 AM8/29/02
to
"Arun" <sarunp...@yahoo.com> wrote:

>I have the same trouble, i have a macro function in VBA
>which i want to load and be executed automatically when i
>open the visio file. but i have it as both DocumentOpened
>and also as DocumentCreated like you have suggested, but
>its just not working and the function is not being invoked
>at all. to test if its invoked, i am throwing an error pop-
>up using Err.Raise function, but nothing seems to be
>getting executed when i open the visio file. pls tell me
>if i am missing something here.

Is your code in the document you're opening?

--
Reinier

0 new messages