Exporting data to VBA created workbook how can I send page data?

[Xaos]

Hello,

I hobbled together a working macro through trial and error. I was wondering if someone could help me clean it up? I would like to learn how to do coding correctly and could use any advice you can give.

Please Login or Register  to view this content.

And also, for this part:

.Sheets.Add(, After:=Sheets(Worksheets.Count)).Name = umName

I would like to copy the contents of the current worksheet to this newly created worksheet on the new workbook.

Can somone maybe help me work out how to do this?

Any help appreciated.