On Jul 20, 11:16 pm, "Ron de Bruin" wrote:
You must usehttp://www.rondebruin.nl/copy5.htm#4)

What have you changed in my example

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Amol" wrote in ooglegroups.com...
On Jul 20, 10:57 pm, "Ron de Bruin" wrote:
Hi Amol

Try the workbook examplehttp://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Amol" wrote in oglegroups.com...
Can anyone please help me in this regards...

I want to split the data in diiferent workbook and save it in new
folder.( every time i split the data the macro should create new
folder for it)

I have data which contains credit and debit details of the clients, i
want to split that data from customer code and save it in foleder with
file name (which contains client code in it )

Please provide me the required VBL query......trying hard for many
days but still not succeded.- Hide quoted text -

- Show quoted text -

Its not working....

i have no idea where the file got saved Plus there is one sheet added
in existing data sheet....

No folder name, no file saved with customer name......

Result = Total confussion- Hide quoted text -

- Show quoted text -

on which location the folder got saved??? Its just a run macro and add
one sheet with no date just a hearder.....
I think i am not able to explain what i want.........if provide the
exact query for same and not a link