+ Reply to Thread
Results 1 to 3 of 3

Open file in "safe mode" with VBA

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Open file in "safe mode" with VBA

    Hi all,

    I have a summary workbook that links to a few other workbooks, now in order to update the links quickly, I want to open and close these other workbooks, but they are rather big in size and often happen to be in "use" as they are all on a shared drive. How can I write a Macro that opens and closes them in "safe mode" or any mode that speeds up the whole opening and closing process? I just need to refresh the data in my summary file. Updating the links while the other files are closed, gets Excel to crash every time.

    Below code is what I'm using currently. Unfortunately, it is incredibly slow and if someone is currently using below file, VBA does not even seem to let me open it.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Open file in "safe mode" with VBA

    I think Read Only is what you're looking for.

    The helpfile is your friend.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Re: Open file in "safe mode" with VBA

    hmm... still seems to be too "big" to have both files open. I guess there's no way to open it in an even more "basic" mode to reduce processing?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open new Excel Instance in Safe mode with VBA
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2020, 12:11 PM
  2. Replies: 4
    Last Post: 11-25-2017, 04:09 PM
  3. """default folder in get open file"""
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2017, 09:40 AM
  4. [SOLVED] Open Workbook in "Full Screen" mode but with sized "Window" View
    By HGL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2016, 05:54 AM
  5. VBA - IE - click on "Open" in an internet explorer "file download" window
    By victoire in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2013, 07:08 AM
  6. Is that safe to save excel file in "macro-enable" ?
    By choy96 in forum Excel General
    Replies: 1
    Last Post: 11-06-2010, 07:00 AM
  7. Word won't open except safe mode
    By Reema in forum Word Formatting & General
    Replies: 1
    Last Post: 04-24-2009, 02:18 AM

Tags for this Thread

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