When manipulating Word from Excel, you have to set Word app to visible, but you don't have to when you work with PowerPoint App. Why?

[Jamualson]

1. If I don't set it to visible, Word is not visible. But at PowerPoint, this step is not needed, PowerPoint is visible no matter what. Why?

2.
I think i know the cause -->

- It seems to me that when creating a new Word application, it launches literally a new application (I tested things with Late Binding) every time i launch the code. If i launch 5 times, then 5 seperate Word app is running (but where is this file, hidden? Or I can find it somewhere? Where does it exist)
- but when I launch the PowerPoint app making code, lets say 5 times (late binding still), it doesnt make seperate apps actually, it stops at the 1 and only adds new presentations. However, late binding should launch a seperate copy of powerpoint app.

I think this is in correlation with the "visible" thing too. (1 causes 2)

Thank you very much for your idea, I find this behaviour a little strange.

Sub Test()

Dim wApp As Object
Set wApp = CreateObject("Word.Application")

Dim wDoc As Word.Document
Set wDoc = wApp.Documents.Add(Template:="Normal")

wApp.Visible = True

Set wApp = Nothing

End Sub

 

[RoryA]

Late or early binding shouldn't make any difference to whether an app launches as a separate instance or not. Some apps are multi-instance by default, some are not.

 

[Macropod]

Whether you need 'wApp.Visible = True' really depends on what you're doing in Word. I regularly use 'wApp.Visible = False' (or the equivalent thereof. Employing 'wApp.Visible = True' can be useful while your code isn't fully tested, though, and is essential if you want to view whatever document(s) you're opening. See, for example:

Merge Word Docs from Excel's VBA

Hi all, Is it possible for Excel's VBA to merge Word docs into one document? It needs to from Excel since in Excel I have a list of word documents. The order of the docs in this list determines the order in which they need to be merged. For example: Excel's list range ("A1:A3"): Cell A1...

www.mrexcel.com

[SOLVED] Use Excel VBA to scan a series of Word TOC entries

www.techsupportforum.com

Having problems copying an Excel range to a Word file using VBA

I have looked at some VBA codes on how to copy a range from Excel and paste to a Word Document, but I can't get it to work, it creates a pdf file, but the file is corrupted. I have the following VB...

stackoverflow.com

support to capture specific data from Word to Excel using VBA Automation

Hello all, I'm trying to automate BOE (Bill of Entry) to Excel for our internal purpose. I need VBA code to find and capture specific data from Word and paste it on Excel under specific fields I have attached Word and Excel for your understanding and highlighted field in which it has to...

www.excelforum.com

 

[Jamualson]

Whether you need 'wApp.Visible = True' really depends on what you're doing in Word. I regularly use 'wApp.Visible = False' (or the equivalent thereof. Employing 'wApp.Visible = True' can be useful while your code isn't fully tested, though, and is essential if you want to view whatever document(s) you're opening. See, for example:

Merge Word Docs from Excel's VBA

Hi all, Is it possible for Excel's VBA to merge Word docs into one document? It needs to from Excel since in Excel I have a list of word documents. The order of the docs in this list determines the order in which they need to be merged. For example: Excel's list range ("A1:A3"): Cell A1...

www.mrexcel.com

[SOLVED] Use Excel VBA to scan a series of Word TOC entries

www.techsupportforum.com

Having problems copying an Excel range to a Word file using VBA

I have looked at some VBA codes on how to copy a range from Excel and paste to a Word Document, but I can't get it to work, it creates a pdf file, but the file is corrupted. I have the following VB...

stackoverflow.com

support to capture specific data from Word to Excel using VBA Automation

Hello all, I'm trying to automate BOE (Bill of Entry) to Excel for our internal purpose. I need VBA code to find and capture specific data from Word and paste it on Excel under specific fields I have attached Word and Excel for your understanding and highlighted field in which it has to...

www.excelforum.com

Thank you, will check out them tomorrow. Do you by the way how an app can be viewed, if its visibility is hiden? Where is tjis file? You can not see this at all? (i mean right click a word document and somehow reveal hidden documents or idk) So it will be unvisible for ever until i dont set it to visible?

 

[Macropod]

If Word is being run with 'wApp.Visible = False', the only way of accessing it through the user interface is by setting 'wApp.Visible = True'; otherwise, you can see it in Task Manager - which is useful if your macro crashes with an open document you can no longer access. Hiding Word or the document (as also demonstrated in some of the links) has no effect on the document's accessibility outside the macro.

 

[Jamualson]

If Word is being run with 'wApp.Visible = False', the only way of accessing it through the user interface is by setting 'wApp.Visible = True'; otherwise, you can see it in Task Manager - which is useful if your macro crashes with an open document you can no longer access. Hiding Word or the document (as also demonstrated in some of the links) has no effect on the document's accessibility outside the macro.

Thank you very much!!! Great insights.