Prev: time compare
Next: Excel window visible!‏
From: Bobby on 7 Oct 2010 14:15
Can someone tell me why do I see the Excel Window(without the sheet)
at the execution of my script that read the first line third column of
a specific sheet? This script run's under XP on my local machine. Here
is my code:

Set app = CreateObject("Excel.Application")
app.ScreenUpdating = False
app.Application.EnableEvents = False
app.Visible = False

Set Workbook = app.Workbooks.Open("Filename.xls")

app.Application.EnableEvents = False
app.ScreenUpdating = False
app.Visible = False
app.Sheets("DAILY").Select

intRow = 1
'Do Until app.Cells(intRow,1).Value = ""
Do Until IntRow = 2
Wscript.Echo "TIME " & CDate(app.Cells(intRow, 2).Value)
introw = intRow + 1
Loop

Workbook.close false
'app.Quit
WScript.Quit

Thank's ahead!
 | 
Pages: 1
Prev: time compare
Next: Excel window visible!‏