Prev: Excel window visible!
Next: Excel window visible!
From: Bobby on 7 Oct 2010 17:26
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 and 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("D:\Robert\DOCUMENT\XLS
\ClasseurDoc.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: Excel window visible!
Next: Excel window visible!