Hi ,
i have written a below code however got stuck in below last lines where i am trying to save the workbook in specific Folder
Save as and xlsb format with Name Updated BaseSheet and the Current Date .
and no need to run another macro when my First Macro Runs and after that it Should save...
I have this working Macro but instead of saving to a specific directory I want it to save to the same directory as the current file.
What can I plug in there that won't change the other functions
Sub saveinvwithnewname()
Dim newfn As Variant
' copy invoice to new workbook
ActiveSheet.Copy...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.