• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Save using Macro

S

Suraj S

New Member
Hi,

I have a Macro file, where after running the macro, i want to save this one particular sheet into a new workbook in a specific folder and then close the newly saved file.

I want to name the new file based upon certain text in a range.
 
Hi and welcome on Chandoo !

Worksheets.Copy method creates the new workbook with worksheet
duplicate. See in VBA inner help as well ActiveWorkbook.Close method
to save and close at once …
​
 
You must log in or register to reply here.
Back
Top