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
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
Application.ScreenUpdating = False
set bk = Workbooks.Open("C:\ABC\myfile.xls")
bk.Windows(1).Visible = False
Application.ScreenUpdating = True
--
regards,
Tom Ogilvy
"TommySzalapski"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks