I want to do late binding on an Excel application object but I am having an Error 1004 (Unable to set the WindowState property of the Application class) if I do it that way. The code runs fine when the Excel object library is referenced.
Thanks for the help!
Code:
Dim objExcel As Object
Dim objWorkbook As Object
Dim objWorksheet As Object
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("W:\System\File (Template).xltx")
objExcel.Application.Visible = True
objExcel.Application.WindowState = xlMinimized 'Error 1004 here
Thanks for the help!