Save File to Desktop VBA

[@jamieharper5665]

Thank you for this! I managed to use this in conjunction with exporting a cell range as a jpeg image! It's a little warped (so not sure what I'm doing wrong there) but it saved to the desktop PERFECTLY! Thanks again! Super helpful! :D

[@thesmallman]

Glad it helped!

[@danieldauber8335]

Super helpful. Thanks for the great content! 👍🏼👍🏼

[@OneSumeet]

Thanks Marus. This is very helpful.

[@thesmallman]

You are most welcome Sumeet.

[@manin4568]

HI Marcus, How to Save File as XLSX/XLSM to desktop using Command button. i have total 4 Sheets , I just want to Save 3 sheets , the command Button stays in empty Sheet.1, Any leads ? please

[@dhirendranathmandal6949]

Sir please want a video for Create a Macro to save Specific Worksheets in specific folder

[@thesmallman]

There are plenty of examples of precisely this on my website. See if the following works for you.
www.thesmallman.com/copy-sheet-and-save
All the very best.

[@rayanaltayyari6450]

How can I loop that with other sheets?

[@thesmallman]

Hi Rayan - yup good question. All you have to do if you want to save each sheet to the desktop is create a sheet reference and loop through each sheet in the WB. I would write it something like this;
Dim sh As Worksheet
For Each sh In Sheets
'Your Code Here :)
Next sh
Now all you have to worry about is where do you put the saving reference for each new sheet. I would use the sheet name as the point of save or a dedicated cell that had some unique identifier.
Hope that helps.
Marcus

[@rayanaltayyari6450]

Marcus Small Thanks and I really appreciate it.

[@siddhartharoy6248]

Sir, How it works on protected sheet

[@thesmallman]

You have to unprotect the sheet with code, then run the code, then reprotect the sheet after the code is run.

[@yosef-yosef9414]

This code are fit when you use other laptop or computer right?

[@thesmallman]

Yes works on any type of computer.