View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveM SteveM is offline
external usenet poster
 
Posts: 133
Default How to open an Excel window hidden

I think you could minimize the Excel instance or set
Application.ScreenUpdating = False from the calling app, then open
Excel, get the data, close Excel and reset Updating = True.

SteveM

On Oct 21, 5:55 pm, "Woody" wrote:
Hello,
I want to open an Excel file from another application, to read some data
from Excel. But i want to keep the Excel window hidden.
The following macro opens the workbook hidden, but the Excel frame still
displays on screen.
How to get rid of this XL window ?
Thanks ahead

Set XLApp = New Excel.Application
XLApp.WorkBooks.Open FileName:=NomClasseurXL
XLApp.Visible = False

Woody