+ Reply to Thread
Results 1 to 6 of 6

Is there a way to suppress a "File Now Available" message?

  1. #1
    Registered User
    Join Date
    04-24-2004
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    92

    Is there a way to suppress a "File Now Available" message?

    Hello,

    I posted this elsewhere but have not received any response.

    I�m receiving an error when attempting to run a select part of my code. There are eight parts of my total routine. However, when testing, it appears the second portion is where my problem occurs (cmdTest2_Click).

    The error is:

    Error.jpg

    Here is a snipit of my code �

    Please Login or Register  to view this content.
    T5 = C:\Users\?????\Desktop\
    T6 = TryMe.xlsb

    I was hoping to find a way to open TryMe NOT as Read Only. I would have thought being Read Only wouldn�t matter as I am only copying from TryMe not modifying it but apparently this is not the case. Any suggestions would be appreciated.

    Thanks for viewing,
    Steve K.
    Last edited by 6StringJazzer; 09-15-2024 at 05:54 PM. Reason: changed HTML tags to CODE tags to make code visible

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,977

    Re: Is there a way to suppress a "File Now Available" message?

    Quote Originally Posted by esskaykay View Post
    I posted this elsewhere but have not received any response.
    Please post a link to your other post.



    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however if the same query has been posted on one or more other forums you must provide a link to your posts on other sites.

    Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-24-2004
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    92

    Re: Is there a way to suppress a "File Now Available" message?

    Here is the link other link as noted.
    https://www.mrexcel.com/board/thread...ssage.1264341/

    SKK

  4. #4
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,046

    Re: Is there a way to suppress a "File Now Available" message?

    Maybe something along these lines. Opens ReadOnly, but disables the Notify option.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-24-2004
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    92

    Re: Is there a way to suppress a "File Now Available" message?

    Thank you ByteMarks for your quick response and suggestion. I added your code to the beginning of my cmdTest2_Click. However, I am still seeing the error message.

    I have another idea I’m working on. Hopefully this will be successful, if not, I’m sure I’ll be back begging for more help.

    Thanks again – much appreciated,
    Steve K

  6. #6
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,046

    Re: Is there a way to suppress a "File Now Available" message?

    Is this workbook Workbooks.Open("" & Range("T5") & Range("T6") & "") TryMe.xlsb, or is TryMe.xlsb the one with cmdTest2?

+ 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. [SOLVED] Macro to Print and suppress Print Dialog Message "Now Printing"
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2023, 08:23 AM
  2. Suppress "Downloading..." and "Saving..." dialogues
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2022, 01:33 PM
  3. Excel 2007 VBA...suppress "opening" message when refreshing pivot data
    By dbiggied in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-22-2012, 10:44 AM
  4. MSoffice Outlook 2003 message to be saved in C dir with the file name "From" "Sent" "Sub"
    By shailendra0509 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 01:32 AM
  5. how to suppress "update links" message for workbook with no links?
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2006, 02:40 PM
  6. Replies: 2
    Last Post: 10-15-2005, 10:05 AM
  7. Replies: 0
    Last Post: 10-12-2005, 12:05 PM

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