Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a workbook in the background (like filestream)
Is there any way to open a workbook for editing without actually having it appear on the screen (like filestream but still with full Excel functionality)? Thanks, Tommy -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=390184 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a workbook in the background (like filestream)
Application.ScreenUpdating = False
set bk = Workbooks.Open("C:\ABC\myfile.xls") bk.Windows(1).Visible = False Application.ScreenUpdating = True -- regards, Tom Ogilvy "TommySzalapski" <TommySzalapski.1ss5iy_1122387046.0315@excelforu m-nospam.com wrote in message news:TommySzalapski.1ss5iy_1122387046.0315@excelfo rum-nospam.com... Is there any way to open a workbook for editing without actually having it appear on the screen (like filestream but still with full Excel functionality)? Thanks, Tommy -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=390184 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open EXCEL.exe in Background using a .BAT File | Excel Discussion (Misc queries) | |||
I don't want to see the background page #s when a .xls is open | Setting up and Configuration of Excel | |||
Excel does not open, just opens a the grey background | New Users to Excel | |||
How to open file in the background. It is possible? | Excel Programming | |||
How to open file in the background. It is possible? | New Users to Excel |