Ryan Simmons
asked on
vbscript to refresh excel data connections specifying 2013
Good Morning,
I have the following vbscript:
The problem is that I have both 2007 and 2013 installed on my machine which is required because all of my customers use 2007 and I need to make compatible worksheets. When I run the script it uses 2007 to refresh the document. Is there a way I can specify to the script that it needs to use 2013?
I have the following vbscript:
Set oexcel = CreateObject("excel.Application")
Set oWorkbook = oexcel.Workbooks.Open("C:\Analytics\Access Databases\Workforce Management\WFMR\Exports\EXCEL\OLAP\2016\OLAP_1216.xlsm")
oexcel.Application.Visible = False
oexcel.ActiveWorkbook.RefreshAll
oexcel.ActiveWorkbook.Save
oexcel.ActiveWorkbook.Close
oexcel.Application.Quit
set oexcel = nothing
set oWorkbook = nothing
The problem is that I have both 2007 and 2013 installed on my machine which is required because all of my customers use 2007 and I need to make compatible worksheets. When I run the script it uses 2007 to refresh the document. Is there a way I can specify to the script that it needs to use 2013?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great feedback and solution.
ASKER