| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open an Excel window hidden
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can only open one window with excel | Excel Discussion (Misc queries) | |||
| Keep VBA window hidden | Excel Programming | |||
| excel open in new window | Excel Discussion (Misc queries) | |||
| Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
| how to open a url in a new window from VBA on Excel | Excel Programming | |||
![Woody[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
