I have a VBS script which i am creating to try and automatically run a report
On this report, the pivots often change and excel will give the message
"Do you want to replace the contents of destination cells in Screen?"
Then it comes up with two other message boxes where user presses "ok" and "ok" again
How can i skip through these with the script. The answer to the question is always yes and to the two message boxes, always press ok....
Can anyone incorporate this into my script?
Dim oXL, oFolder, aFile, FSO
Set oXL = CreateObject("Excel.Application")
Set FSO = CreateObject("Scripting.FileSystemObject")
oXL.DisplayAlerts = False
oXL.Workbooks.Open("G:\Asset Services Risk Team\Internal ACS\Internal Accounts Report.xls")
oXL.ActiveWorkBook.Close SaveChanges = True