Excel VBA - hide path while saving file to another location

Question

I have a nice, short macro that does a "save as" of an active workbook to a specified path. All works fine, however I would like to hide the prompt or at least the path that pops up ("uploading to C:/blabla/blabla/ location") - because I don't want the users to be able to see the path name or where the file is uploading.

I have tried Application.DisplayAlerts = False but it doesn't seem to do the trick. Do you have any tips on how to achieve this?

Thanks, Coco

Apurv Pawar Apurv Pawar · Accepted Answer · 2017-05-26T12:25:54

is it a message box or something else because a script like below does not give out a pop up.

Sub net()

ActiveWorkbook.SaveAs ("D:\dave\abcd\Desktop\abcd.xlsx")
End Sub

Excel VBA - hide path while saving file to another location

1 Answers