Creating separate workbooks using a macro

[Jason Tan]

Respected users,


Can we create a macro which would help us to create separate workbooks; for example, we have workbook named A, can we create workbook B and workbook C using a macro function in workbook A?

If not, is it possible using excel related time saving tools?

Thank you.

 

[sykes]

Hi, and welcome to Mr. Excel!

Yes, you can do this.

Suggest that, rather than create extra new posts for this sort of thing, use the excellent search facility - there are literally 100s of 1,000s of posts - which is the whole idea - to give Folks a fantastic searchable database of Excel-related knowledge.

I did a very quick search and came up with many possibilities - one of which was: https://www.mrexcel.com/forum/excel...e-workbook-code.html?highlight=code,+workbook

 

[Fluff]

Hi & welcome to MrExcel.
The simple answer is yes, but we would need a lot more information regarding what exactly you want.