Why vba code stops working after a document open command?

eduzs · #1 08-23-2017, 06:51 AM

I have this simple code:

Code:

Option Explicit

Global GlobDoc As Document

Sub Call_Autotexto()

Dim AppDoc2 As Document

Set GlobDoc = ActiveDocument

Set AppDoc2 = Documents.Open("E:\X\_AutoTexto.docm", Visible:=False)
Set AppDoc2 = Nothing

MsgBox "oi"

GlobDoc.Activate

End Sub

The "AutoTexto" have some complex vba code that runs and closes itself, but there's no "Oi" msgbox.

The code after documents open seems not working.

Any ideas?

Thanks.

macropod · #2 08-23-2017, 03:02 PM

Maybe that's because something in _AutoTexto.docm - a macro enabled document - is trying to run but requires user input before it can continue. With 'Visible:=False' you'll never see what that is...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drag and Drop Stops Working	TucsonJack	Word	7	04-26-2023 04:36 PM
when using find in vba several times it stops working	Salah	Word VBA	1	03-02-2017 03:02 AM
Outlook Stops Working	TOKonline	Outlook	0	09-26-2014 05:39 AM
Uncheck Checkbox Code not working if document protected	bandrist	Word VBA	2	08-14-2013 09:02 AM
VB code from one document runs on other open documents	beav_35	Word VBA	0	11-10-2010 02:52 PM