Windows 10: Problem with Excel macro to open Word files

Discus and support Problem with Excel macro to open Word files in Microsoft Office and 365 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 'Microsoft Office and 365' 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. How Can I get macros to work in Excel and Word

    in Windows 10 BSOD Crashes and Debugging
    How Can I get macros to work in Excel and Word: I'm using personal individual Office 365 and every time I try to create a macro, the application closes. What setting changes do I need to make so that macros will work?...
  3. Macros Crashing Upon Create in Word and Excel

    in Windows 10 BSOD Crashes and Debugging
    Macros Crashing Upon Create in Word and Excel: Every time I hit Create when trying to create a macro in Excel or Word, the application crashing. It just closes. Sometimes it'll reopen and sometime it won't. I've tried every setting possible in order to fix but nothing works. I tried customer support about 50 times...
  4. Word & Excel do not open

    in Windows 10 Customization
    Word & Excel do not open: Hi. When I try to open excel, I have the following message: "Microsoft Excel isn't currently your default program for viewing and editing spreadsheets. Do you want to select file types that Excel should open?" I chose "Yes" and tried to follow but came to nothing. Word...
  5. 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'...
  6. Problem with Excel macro to open Word files

    in Windows 10 Support
    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...
  7. 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...
  8. 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...
  9. 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
  10. "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...