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
Save as (filename,fileformat) from Word VBA will not work 1
How to make scroll bar permanently visible, Word 365 0
Add additional information to excel form after original data entry 0
Export BPMN Visio Chart to Excel 0
Merging from an Excel file with graphics 1
Open a New Instance of Excel 3
Open file and keep it hidden 0

Top