R
rosen
If I want to perform a data base update (i.e. same as hitting "!" in
the UI) from a vbscript what command should I use....
SpreadSheet = "D:\test.xls"
' Create the Excel application object
Dim Excel
Set Excel = CreateObject ("Excel.Application")
Excel.Visible = True
Excel.Workbooks.Open SpreadSheet
Excel.Refresh <---- This is giving me an error
Excel.Workbooks.Close
Excel.Quit
the UI) from a vbscript what command should I use....
SpreadSheet = "D:\test.xls"
' Create the Excel application object
Dim Excel
Set Excel = CreateObject ("Excel.Application")
Excel.Visible = True
Excel.Workbooks.Open SpreadSheet
Excel.Refresh <---- This is giving me an error
Excel.Workbooks.Close
Excel.Quit