'Enable Editing' problem when viewing doc as attachment

[Robie]

Another 2010 tantrum.

We have found that attached document to an email when opened are fine but if you 'Enable Editing' then it fails with a VBA error.

18.png

This is due to the VBA code not finding ActiveDocument.

17.png

On the other hand if document is opended from Windows Exploder then it is fine.

The template was created in 2003 but saved as DOTM under 2010.

Thanks.
Robie

[agibsonsw]

I'm guessing that the MS code that runs when clicking Enable Editing temporarily removes (closes) the ActiveDocument, and at the point when your template code also runs there is no ActiveDocument. (The MS code doesn't so much enable editing as close and re-open an editable version of the document.)

Not sure how you can surmount this, other than by not opening from an attachment. There is a Word option in the Trust Center to not use Protected Mode, but this would have to be chosen by each individual (or globally) and is not recommended.

But I'm sure someone will correct me if I've mis-understood

[HansV]

Andy's explanation looks plausible to me. You could test for a document being open:

If Documents.Count = 0 Then Exit Sub

[agibsonsw]

Editing your code to get around this issue may be problematic. It might be worth considering using a Timer interval to delay your code from running; that is, with a suitable interval to ensure that the MS process has completed.

[Robie]

Andy's explanation looks plausible to me. You could test for a document being open:

If Documents.Count = 0 Then Exit Sub

Just tried it but documents.count is actually 1.

[agibsonsw]

Code: Select all

Private Sub Document_New()  'or Open if applicable
    Application.OnTime When:=Now + TimeValue("00:00:05"), _
        Name:="Macro1"
End Sub

..if it helps

[Robie]

Editing your code to get around this issue may be problematic. It might be worth considering using a Timer interval to delay your code from running; that is, with a suitable interval to ensure that the MS process has completed.

Thanks but this could be problematic as well, how long an interval since all document sizes are different.

[agibsonsw]

I suppose you could cause the timer to repeat with a short interval, checking each time for an ActiveDocument, with error handling to ensure the code doesn't bail.

[HansV]

I'd recommed instructing users NEVER to open attachments directly. Always save to disk, then open the saved version.

[agibsonsw]

I'd recommed instructing users NEVER to open attachments directly. Always save to disk, then open the saved version.

The better approach

The question also arises - if it's a template, doesn't it need to be saved somewhere anyway?

[Robie]

I'd recommed instructing users NEVER to open attachments directly. Always save to disk, then open the saved version.

Now you are talking Hans - words of wisdom.

Unfotunately, no one listens to me. At the moment thinking of removing protected view but may have to have a rethink on that one.

[StuartR]

I get the same problem when I open Word documents from a secure web page provided by one of my customers. I just ignore the error and carry on working.