Windows 10: 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?

:)

 

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

 

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!

 

Ez Macros or any other Macro program

Hi Brian,

The issue is quite unclear and too broad for us to distinguish the main reason why you are having challenges/issues in Macro. To have a better understanding of your concern, we'd like to ask you some questions:

• Are you referring on using macros on Excel? If yes, what is the version of your Office?
  
• What exact application are you using when using macros? Where did you download it?

• What were the recent changes made on your computer before you experienced this issue?
• What troubleshooting steps have you done so far?
• Did you receive any error message?

Your response will be much appreciated.