How to hide "downloading file" box from VBA

  • Hi All,

    I have some code that is opening a secure file in a hidden folder (this data is sensitive and all I need VBA to do is perform calculations on it).

    The code works fine, however the downloading file box from excel actually shows the files path.

    How can I remove that?

    I've the following at the start which is not solving this problem

    Application.Calculation = xlCalculationAutomatic
    Application.ScreenUpdating = False
    Application.DisplayStatusBar = False
    Application.EnableEvents = False
    ActiveSheet.DisplayPageBreaks = False
    Application.DisplayAlerts = False
    Application.AskToUpdateLinks = False

  • Hi,

    Right before your instruction which opens your file ... you could insert following

    Application.SendKeys "{ENTER}"

    Hope this will help :wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!