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


    Code
    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!