asked on

need help with vbscript to consolidate multiple work books with multiple work sheets into a new workbook

hi,
Thanks for the help previously. Now i am working on script where i need to merge data from multiple work books with multiple work sheets in each and get resultant merged data into new excel file. help me with it.

thanks & regards,
sunny

Shums Faruk

Sunny,

You mean, you want Master File where you get consolidated data, to create a new workbook? If yes, then do you need any specific name for newly created workbook?

sampath sunny

ASKER

yes, i need script to get consolidated into new work book which should be created itself with name output

thanks,
sunny

Shums Faruk

What will be name output? Will it be fine if I name as Last Day of the current month?

sampath sunny

ASKER

yes

Roy Cox

Do you want all sheets from each workbook merged to one sheet in the master workbook?

Are there any sheets to exclude from the copying?

Are all the source workbooks in one folder?

sampath sunny

ASKER

i need to merge the data of multiple work books(a,b,c) having multiple work sheets(1,2,3) in each. then i need merged output as work book d having work sheets 1(a1,b1,c1) , 2 (a2,b2,c2).

thanks,
sunny

ASKER CERTIFIED SOLUTION

Shums Faruk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Shums Faruk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial