Open a workbook in the background (like filestream)

T

TommySzalapski

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
 
T

Tom Ogilvy

Application.ScreenUpdating = False
set bk = Workbooks.Open("C:\ABC\myfile.xls")
bk.Windows(1).Visible = False
Application.ScreenUpdating = True
 

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

Why do charts disappear? 2
Insert a file ito sql-database via Excel wo filestream 2
Excel is removing Macros from workbook 3
How to change a sheet name without opening the workbook 3
problem with FileStream and excel 7
Filestream 2
Displaying FileStream from SQL Server 2008 to Access 2007 0
Open a word mail-merge document from Excel VBA 1

Top