Save File to Desktop VBA

[@OneSumeet]

Thanks Marus. This is very helpful.

[@thesmallman]

You are most welcome Sumeet.

[@danieldauber8335]

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

[@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!

[@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

[@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.

[@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.

[@yosef-yosef9414]

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

[@thesmallman]

Yes works on any type of computer.