vba, IE, word, host application

E

eclips

Hello,
If I open a word or excel document with a hyperlink the autoopen macrocode
generates an error: method failed because the document is open in internet
explorer instead of word (excel).
Can I trap the code with a nice message like: "uncheck the checkbox 'open in
same window'" in order to work with macros. I tried everything:
application.name, parent, windows etc but all these give word as result but
I want to see internet explorer as a result in the direct window. Is there a
solution?
A much nicer way seems to me: uncheck the checkbox by vba code but I dont
think that is possible, or yes?
Thanks a lot
 
J

Jezebel

No. By default, if you open an Office document using the browser, macros are
disabled. Otherwise it would always be an unacceptable security risk to open
Office documents from the web.
 
E

eclips

On my system the autoopen macro fires normally with a messagebox "test" in
internet explorer
Thanks for the reaction
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top