Results 1 to 6 of 6

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

Threaded View

  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 �

    Private Sub cmdTest2_Click()
        Application.DisplayAlerts = False
        Workbooks.Open("" & Range("T5") & Range("T6") & "").RunAutoMacros Which:=xlAutoOpen
    End Sub
    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

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