+ Reply to Thread
Results 1 to 2 of 2

Prompt to open file, but if open already don't ask

  1. 01-10-2013, 03:01 PM #1
    scott.s.fower
    scott.s.fower is offline
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Prompt to open file, but if open already don't ask

    I have some code that I have used many times to prompt to open up a file, but this time I don't want it to prompt me if the file is already open as I will be using the file multiple times within the same macro. The first code block is the above mentioned prompt, the second code block is the macro in its entirety (just in case). Some of the below code was used from http://www.rondebruin.nl/ so thanks to him for his work!

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-12-2013, 05:16 AM #2
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Prompt to open file, but if open already don't ask

    Hi, scott.s.fower,

    in your code you use the line
    Please Login or Register  to view this content.
    You have to add a loop for all workbooks there like this for the last If-Statement
    Please Login or Register  to view this content.
    You may the use the wbOpen for the further action as the newly opened workbook.

    HTH,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1