How to open an Excel window hidden

W

Woody

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
 
S

SteveM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pass parameters to excel from wscript (Windows script) 5
Open a New Instance of Excel 3
Click on the Cancel button 4
How to Cancel the Protect of Excel with VB and save it with a new password again 1
Open Excel workbook from Access 4
Runtime Error '7': Out of Memory 3
Set a reference to a Workbook w/out opening the Workbook? 4
Workbook Open method 2

Top