B
Bobby
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!
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!