Hi All - This is in vbscript and not VBA, but figured the VBA MSFT community might have an answer/explanation of this.
What is the difference between these two methods of getting a currently running Excel process?
Set objExcel = GetObject( , "Excel.Application")
vs.
Set objExcel = eval("getobject(,""Excel.Application"")")
Which is the preferred method? Using the second line, I am curious if this leads to some inconsistencies in our scripts (ie .quit still has a 'do you want to save' popup despite calling objExcel.DisplayAlerts = false
Many thanks in advance!
What is the difference between these two methods of getting a currently running Excel process?
Set objExcel = GetObject( , "Excel.Application")
vs.
Set objExcel = eval("getobject(,""Excel.Application"")")
Which is the preferred method? Using the second line, I am curious if this leads to some inconsistencies in our scripts (ie .quit still has a 'do you want to save' popup despite calling objExcel.DisplayAlerts = false
Many thanks in advance!