How to Export UserForm with VBA to new Excel file

**Sweekar** · 09-14-2011, 10:26 PM

Hi,

I am copying an existing sheet to a new Excel file by using following code.

Please Login or Register  to view this content.

above code only copies the sheet in new Excel File, I want to export an existing UserForm from the same file to the new file as well.

Any help is greatly appreciated.

Regards,
Sweek

**royUK** · 09-15-2011, 01:53 AM

Why not use saveas & delete the other sheets from the new workbook? That's easier than attempting code to copy a userform

**Sweekar** · 09-20-2011, 08:09 AM

I am creating a template that will be used by multiple users.
Concept is like Data Entry-
1. I have a UserForm and whatever data entered by user is saved in a new workbook.
2. I am placing a View Data button on the New workbook that is output of step 1.
3. what i need is on click of view data button same form that i used for Data entry in step 1 should just show the data.
4. so on creation of new workbook if i export the existing form as well it all solves my problem.