Prev: Excel window visible!‏
Next: Invalid root in registry key ...
From: Bobby on 7 Oct 2010 14:20
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 ofa
specific sheet? This script run's under XP on my local machine. Hereis
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: Invalid root in registry key ...