Recent content by SuperMaximus

The problem hides in ".Show" command. If I use ".Execute" I don't see annoying excel.exe process in TaskManager anymore, nevertheless I need to see the dialog (which can't be seen when I use ".Execute"). I can't believe there's no way out.

PHV, What if I don't want to close Word Application? It the case described above (without calling .Dialogs) when I close Excel application the corresponding process excel.exe disappears from memory. Anyway, adding WordApp.Quit along with the usage of With wrdDialogs(wdDialogFileSaveAs)...

I Found the reason for excel.exe process running !!!! Here, again, I'll post the code of a completed sub: Sub RunContract_Automation() Dim ContractPath As String Dim WordApp As Word.Application Dim WordDoc As Word.Document Dim wrdMailMerge As Word.MailMerge Dim wrdDialogs As...

No, I don't. This ;Jet OLEDB:Engine Type=35;Je" _ was automatically recordered by MS Word. I have no idea of what "Je" can be... But after recording the macro of Merge procedure I got Connection:= _ "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data...

PHV, unfortunately... it didn't help. I've made everything look explicit .Documents("CONTRACT.doc").MailMerge.MainDocumentType = wdFormLetters .Documents("CONTRACT.doc").MailMerge.OpenDataSource name:="D:\AWB\WORK.xls", _ ConfirmConversions:=False, ReadOnly:=False...

I have read all of the similar threads and haven't found a solution of the problem of Excel.exe process running in Task Explorer after closure of both Word & Excel Applications. As you see in the code below I've set WordApp and WordDoc both to 'Nothing' at the end of macro. Option Explicit...