Macro to create new workbook and save it after formatting

[vijanand1279]

Looking for a macro to create new workbook with all the three sheets "Sheet1, Sheet2, Sheet3" information on that.
Once the new workbook is created, I want to save the new workbook with name from input box.
I have attached the sample "new workbook". I am looking the new workbook to look like the attahched sample.

Please help

[davesexcel]

Try pressing F12.............why not just save as a new name?

[vijanand1279]

Try pressing F12.............why not just save as a new name?

I have create new workbook for the sheets I have in Master.xls (2-4th) and then save the new workbook in the same folder, to save file use input box to enter file name.

Every time when I run the macro in master.xls the sheets 2-4 should be created as a new copy.

Please help

Regards,
Vijay

[davesexcel]

Try This

Please Login or Register  to view this content.

[vijanand1279]

It creates new workbook and saves in the same folder where the macro file is available. But when I open the "New workbook" it prompts me below message

"The File you are trying to open, "New Workbook", is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

Please help to resolve this.

Regards,
Vijay

Any thought?

[davesexcel]

Try this

Please Login or Register  to view this content.