You can use VBA to prompt the user to enter a filename for an Excel spreadsheet and then save the file where the user has indicated.

How to Save an Excel Spreadsheet to Your Desktop. Your computer's desktop is often the easiest and most convenient place to store files, especially those you use often.

If you are needing to bulk-convert new Excel .XLSM files to the older .XLS format, this Macro will handle it for you. It automates opening and Saving-As. This does not just "rename" the file, it will ...

This VBA Excel script is designed to extract the paths of all files within a specified folder and its subfolders. It presents a user interface to select the folder, and then prompts for the type of ...

Try saving the Excel workbook file to the local hard drive. You can also try to save the workbook to the folder in which you have rights for modification and deletion.