Copying a userform from one project to another

[calmena]

Hi,

I have recorded a macro and assigned it to a pushbutton. When the button is selected, the macro that will run will copy the current workbook and open a new blank workbook and past the sheets into the new workbook. The only problem with this is, it doesn't copyt the user form that I have created.

Does anyone know how to have the userform copied from one workbook to another using macro code?

Thanks in advance.

[Colin Legg]

Hi,

It sounds like you're copying everything over? You could simply use the Workbook.SaveCopyAs method instead?

[calmena]

I don't think that will apply in my case, because the user would be saving the workbook already prior to running this copy macro. It works like this.

The user will use the workbook one day, and at the end of the day they will save their workbook. The next day, they will open yesterdays' workbook, and simply hit the macro to copy everthing and create a new workbook for the next day. but in doing this, they will lose the userform that they need to fill out as part of the work book.

thnaks.

[calmena]

its interesting to me because in my macro to copy everything over, I only tell it to copy the worksheets, but it also automatically copies the modules; which is good, but it also needs to copy the userforms.

[Colin Legg]

I don't think that will apply in my case, because the user would be saving the workbook already prior to running this copy macro. It works like this.

The user will use the workbook one day, and at the end of the day they will save their workbook. The next day, they will open yesterdays' workbook, and simply hit the macro to copy everthing and create a new workbook for the next day. but in doing this, they will lose the userform that they need to fill out as part of the work book.

thnaks.

Workbook.SaveAs or Workbook.SaveCopyAs both sound perfect for this then.

If you use Workbook.SaveAs, the user just clicks the button and yesterday's workbook will be saved as today's workbook, and then they are ready to rock and roll?

Both of these methods will keep the userform.

[calmena]

Ok, I will give it a try. Can you tell me how to use "workbook.saveas"?

Do I insert it in VBA somewhere or do I insert it in the macro module somewhere?

Thanks.