+ Reply to Thread
Results 1 to 2 of 2

Open a workbook in the background (like filestream)

  1. #1
    Registered User
    Join Date
    07-25-2005
    Posts
    62

    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

  2. #2
    Tom Ogilvy
    Guest

    Re: 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"
    <[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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1