So I want to initiate the save as for the file when the user clicks the "Finalize report" button but there's a small difficulty
I have the name for the file and the location of the file in a sheet that takes todays date and formats it to match the location of the file in the network drive and the date format that I want it saved.
File Address should be:
<tbody>
</tbody>which is in cell B25 on the file locations sheet in the workbook
File should be named 03-28-2019
as located in cell B24 on the file locations sheet in the workbook.
Im hoping it will do the save as on its own, maybe just open a MsgBox to say "Are you sure youre ready to save the file"
Any help would be greatly appreciated.
I have the name for the file and the location of the file in a sheet that takes todays date and formats it to match the location of the file in the network drive and the date format that I want it saved.
File Address should be:
I:\Inventory\Quality Reports\2019\3-2019 |
<tbody>
</tbody>
File should be named 03-28-2019
as located in cell B24 on the file locations sheet in the workbook.
Im hoping it will do the save as on its own, maybe just open a MsgBox to say "Are you sure youre ready to save the file"
Any help would be greatly appreciated.
Last edited: