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