AutoOpen

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gitche Gumee - 22 Nov 2006 22:24 GMT

My AutoOpen macro has stopped working. It's this:
ActiveWindow.Caption = ActiveDocument.FullName

If I open a document using File | Open, it works.

Double-clicking a document name or icon does not work. Once the document is
open, though, I can run the AutoOpen macro manually and it works.

Any thoughts?

Windows XP, Office 2002

Reply to this Message

Helmut Weber - 22 Nov 2006 22:48 GMT

Hi Gitche Gumee,

try:

Sub autoopen()
MsgBox "autoopen"
Application.OnTime _
When:=Now + TimeValue("00:00:02"), _
Name:="autoopenX"

End Sub
Sub autoopenX()
ActiveWindow.Caption = ActiveDocument.FullName
End Sub

There were dicussions here on
"how to determine if a document is fully loaded",
just in case you want to know it all.

It is a matter of multitasking,
asynchronous processing,
which might not have been a good idea after all,
at least in the way it was implemented.

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Reply to this Message

Gitche Gumee - 28 Nov 2006 17:55 GMT

After much wailing and gnashing of teeth, I have solved the problem. The DOC
file extension had become disassociated from Word. In Folder Options, the DOC
extension was listed as file type "DOC file" rather than "Microsoft Word
Document." Word still opened up the document but without running the autoopen
macro.

I reassigned the DOC extension to Microsoft Word, and all is well. Thanks
for your assistance.

> Hi Gitche Gumee,
>
[quoted text clipped - 19 lines]
> which might not have been a good idea after all,
> at least in the way it was implemented.

Reply to this Message

Rate this thread: