+ Reply to Thread
Results 1 to 5 of 5

Macro to select "Continue" when opening another file and prompted to update links

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    26

    Macro to select "Continue" when opening another file and prompted to update links

    I have a macro written to open another file, save it, then close it. That part works fine, but when I open the file, it first asks me if I want to update links, I have to click "Update", then it says again that all links couldnt be updated and if I want to continue. I click "Continue". I want to have both of those "clicks" written into the macro so it all happens automatically. How do I do this?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Macro to select "Continue" when opening another file and prompted to update links

    If you want, or don't want, links to be updated there's an argument, UpdateLinks, that can be used with Workbooks.Open.

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Macro to select "Continue" when opening another file and prompted to update links

    Right, I have that to "Update Links" when I am first prompted, but then I get another prompt that says "some links cant be updated, so you wish to continue" and I want to have it auto-select "continue"

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Macro to select "Continue" when opening another file and prompted to update links

    The only other thing I can think of is this.
    Please Login or Register  to view this content.
    Can you post your code?

  5. #5
    Registered User
    Join Date
    08-03-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Macro to select "Continue" when opening another file and prompted to update links

    Popup.JPG
    Please Login or Register  to view this content.
    DisplayAlerts did not work. Attached is an image of the prompt I want to hit continue at.
    Last edited by JosephP; 10-25-2012 at 12:13 PM. Reason: add code tags

+ 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