Windows 10: Problem with Excel macro to open Word files

Discus and support Problem with Excel macro to open Word files in Windows 10 Support to solve the problem; 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... Discussion in 'Windows 10 Support' started by Saxon, Jan 27, 2019.

  1. Saxon Win User

    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!

    :)
     
    Saxon, Jan 27, 2019
    #1
  2. Nit_93 Win User

    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
     
    Nit_93, Jan 27, 2019
    #2
  3. 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.
     
    Joy Kemprai, Jan 27, 2019
    #3
  4. yapchagi Win User

    Problem with Excel macro to open Word files

    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.
     
    yapchagi, Jan 27, 2019
    #4
Thema:

Problem with Excel macro to open Word files

Loading...
  1. Problem with Excel macro to open Word files - Similar Threads - Problem Excel macro

  2. File Explorer - Word and Excel Files not responding

    in Windows 10 Network and Sharing
    File Explorer - Word and Excel Files not responding: When I open File Explorer I can see all my folders and documents. If, for example, I open a folder in One Drive and choose a word or excel file, it will not open. I get the message that the file folder is not responding. I am able to access the files by using Excel or...
  3. Excel - Word: How to change the file open dialogue?

    in Microsoft Office and 365
    Excel - Word: How to change the file open dialogue?: In case of long file names both Excel and Word show a part of the name only in the file open dialog. This is because the rest is blocked by an unused, i.e. empty area on the right hand. This is really annoying. File names may show additional information in the 'blocked'...
  4. Problem with Excel macro to open Word files

    in Microsoft Office and 365
    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...
  5. Word, Excel outlook not opening

    in Windows 10 Software and Apps
    Word, Excel outlook not opening: when I try to open any of the following Microsoft word, excel, powerpoint outlook nothing happens. The screen just spins for ever and it is not working and no error message is given...
  6. Word and Excel Not Opening and D2d1.dll File Issues

    in Windows 10 BSOD Crashes and Debugging
    Word and Excel Not Opening and D2d1.dll File Issues: I've been having two issues with my laptop for a few days. The first being every time I start up my laptop, I get an error message saying "The code execution cannot proceed because d2d1.dll was not found. Reinstalling the program may help." I'm not entirely sure what that...
  7. Add a shortcut to an Excel Macro

    in Microsoft Office and 365
    Add a shortcut to an Excel Macro: W10 and Excel. I have several macros in my personal.xls all activated from a customized ribbon or Quick Access. I would like to add a KB shortcut to 2 of them. I know I should have done that when I created them but I did not realize then how helpful it would have been My bad...
  8. cannnot open excel or word

    in Windows 10 BSOD Crashes and Debugging
    cannnot open excel or word: I cannot open office or word today. I am on a time crunch and I m not sure what's going on. https://answers.microsoft.com/en-us/windows/forum/windows_10-performance/cannnot-open-excel-or-word/15f4675b-a2ea-4052-9d20-60989f3f93bf
  9. "Connect a smart card" dialog when opening excel file with macros

    in Microsoft Office and 365
    "Connect a smart card" dialog when opening excel file with macros: I have Excel 2010 installed on Windows 7 and windows 10 (same computer). No problem with Windows 7. On windows 10 when I open an .xls or a .xlsm file containing self-signed macros and macro security set to block unsigned macros, I get a "Windows Security" dialog asking me to...
  10. Unable to open excel or word after a restore

    in Microsoft Office and 365
    Unable to open excel or word after a restore: Hello! I've had problems for last couple of days with duplicate drives appearing in the navigation window. After trying lots of things I decided to restore to before the last windows update. Everything seemed ok until I tried to open Excell, I get an error message "not...