create new workbook, copy data, rename sheet.

Hi all
My aim is to click a commandbutton in a userform with 4 textboxes.
Then a new workbook must be created, the data must be pasted and the sheet must be named after textbox2. After this the sheet must contain the values of the userform textboxes values, then it must save the workbook and name it from textbox1 or activesheet range for textbox1.

This is my current code:

Please Login or Register  to view this content.

Any help will be appriciated, thanx

Please Login or Register  to view this content.

you created a new Workbook, now ThisWorkbook is NewBook
the correct code is

Please Login or Register  to view this content.

Hi, patel45,

you´re sure about

you created a new Workbook, now ThisWorkbook is NewBook

ThisWorkbook can only be the workbook with code while ActiveWorkbook can be any active workbook (either ThisWorkbook when the code starts or any other workbook).

@simeonmein

Please Login or Register  to view this content.

I´d guessed to read it like

Please Login or Register  to view this content.

vbNullString and "" should be very very similar to each other but if you want to compare values from a textbox you would need to mention this in both parts of the comparision (you can´t check one textbox for two conditions unless you use Select Case).

Ciao,
Holger