Generating a macro output in a seperate workbook

Hi All,

I have worked a simple macro that manupulates numbers in a range example: A1:H60....
and saved in as template...

after i run the macro in template it should export the output ie: ranges A1:H60 in a new workbook, that i can save seperately...

Thanks...

Hello bmbalamurali,

This should work for you. I will copy the range A1:H60 of the active sheet, create a new workbook with a single sheet, and paste the contents into it.

Add a new VBA Module to your workbook and paste the macro in it. Change the range if needed.

Please Login or Register  to view this content.

Hi Hectop, Thanks....

Hi Leith Ross,

Thanks....

I tried your code and its genarating a new workbook but with empty cells and showing a debug error... in below code...

Please Login or Register  to view this content.

and also tell me whether i can change the range from A1 to any cell range ie: H60, H61, H62 etc....

I have attached an excel.. which has a macro to organise a date from sheet1 to sheet2.... after organising data i need my desired range to be populated in a new workbook...
I have created the macro of my excel with help of forum guru (HaHoBe)......

where in sheet 2 my output range starts from B2 to H60 this is because the sample size i have mentioned in the excel so based on the sample size my range may vary from B1 to H60,H61,H62...etc....

Kindly come back if am not clear, request your support in accomplishing my need...

Kindly look into it.. and provide me a solution... Thanks...

Hi, bmbalamurali,

please check the codename of the sheet in the new workbook - it might not be Sheet1 in the version you use (for me using a German Version it´s Tabelle1):

Please Login or Register  to view this content.

As the new workbook is active when being added you may use

Please Login or Register  to view this content.

instead if you won´t use WKB thereafter.

Ciao,
Holger

Hi HaHoBe,

Thanks working fine... and i also incorporated it in my macro and working great...

Schönen Dank