Word 2010 VBA: Upon opening Excel Application, need to maximize the window
Posted on 2015-01-14
I have created the following code for MS Word VBA to open Excel and create a new file based on a template. The macro is working fine, but I need to maximize the Excel window. Can someone tell me how to do that?
Dim xlApp As Object, xlDoc As Object
Set xlApp = CreateObject("Excel.application")
xlApp.Visible = True
Set xlDoc = xlApp.workbooks.Add("c:\users\dkong\AppData\roaming\microsoft\templates\Work_Slip_January_2015.xltx")