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

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