Logically, you'll likely want your Excel VBA SaveAs button to actually save the file using the file path that the user provided rather than just discarding that name. You can use the SaveAs method ...

You can show File Path on Title Bar in Excel and Word by creating and running a Macro - and even in Quick Access Toolbar too. This post explains the process in detail.

If the Save button is grayed out in Word, Excel, or PowerPoint, this guide will help you get rid of this problem. Although the solution is very straightforward and it doesn’t take much time to ...