Excel window visible! - 77421

  • Follow


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!
0
Reply Bobby 10/7/2010 6:20:07 PM

0 Replies
523 Views

(page loaded in 0.006 seconds)

4/15/2014 12:15:48 PM


Reply: