Windows 10: Problem with Excel macro to open Word files

I am having a problem with an Excel macro which opens Word files. The macro opens the files OK but sometimes the file is not visible; instead, it is hidden in the window behind the Excel Workbook and the Word icon on the taskbar flashes to show that the file is open. I want the Word file to appear visible on-screen automatically without my having to click on the taskbar.

The relevant part of the macro is:

Set objWord = CreateObject("Word.Application")
With objWord
.Documents.Open DocsFullPath(i)
.Visible = True
.Activate
.Application.WindowState = 1
.ActiveWindow.ActivePane.View.Zoom.Percentage = 100
End With
GoTo Finish

Can anyone help me resolve this? It's been driving me mad!

:)

 

excel to word conversion using macro

Hi Microsoft

I need to know how to convert an excel sheet in a workbook to a word document using macros

 

FIles in Word, Excel and other programmes will not open from the explorer

Hi Brian,

Thank you for posting in Microsoft Community and thanks for providing us an opportunity to assist you.

Please follow the steps.

Step 1:

Lets try to disable the DDE option following these steps:

• Click the File tab, and then click
  Options.
• Click Advanced, and then click to clear the
  Ignore other applications that use Dynamic Data Exchange (DDE) check box in the
  General area.

Click OK.

Step 2:

If the issue persists, uncheck the compatibility options by doing the following:

Right click on Excel (.exe) Properties > Compatibility > uncheck all the boxes

To access Excel (.exe), open the following location:

Windows 8 32bit: C:\Program Files\Microsoft Office\Office14

Windows 8 64bit: C:\Program Files(x86)\Microsoft Office\Office14

For reference:
http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/there-was-a-problem-sending-the-command-to-the/56ee1743-b476-43a5-9b00-169b8c6ef37a

Hope the suggestion is helpful. Reply for further assistance.

 

Word and Excel documents are slow to open in Windows 10

in my case, I don't need to restart windows. Closing cortana completely will make opening word and excel files fast like usual.