Prev: Find and Replace
Next: how to open a password protected powerpoint file by Excel
From: Brad Kelly on 2 Jun 2010 11:50
Hello all,

I have a simple script saved as "C:\refresh_excel.vbs" that opens an
Excel file, and does a refresh for a query on Sheet 1. I created a
scheduled task to run this every day.


It worked fine for previous versions of Excel, but since I have
upgraded to Excel 2007 it doesn't work. Any help it helping me figure
this out would be appreciated.


/*contents of refresh_excel.vbs*/
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls")
objWorkbook.Sheets("Sheet1").QueryTables(1).Refresh
Wscript.Sleep 6000
objWorkbook.save
objWorkbook.close
objExcel.Quit
 | 
Pages: 1
Prev: Find and Replace
Next: how to open a password protected powerpoint file by Excel