Code Adjustment split to csv

[farrukh]

Hi Watersev,

This is your sent code to me which perfectly worked only little amendment required.

1. Hard coded the excel master.xlsm (path in the folder) Code do not browse to search.

2. when it creates csv in the result folder ( It creates the name of csv like sheet1,sheet2,sheet3 and so no) i need the name of worksheet tab as a .csv file name suppose worksheet tab name is test then create csv in the result folder like test.csv.

The code is below

Please Login or Register  to view this content.

Thanks
farrukh

[watersev]

hi, farrukh, are you sure the sheet names will be unique otherwise an error occur?

[watersev]

Please Login or Register  to view this content.

[farrukh]

Dear Watersev,



I have the worksheet names in the master.xlsm like guest1,guest2,guest3,administrator1 so on..

I need that code do not search or browse the file directly hard coded the path= "D:\Myworks\Master.xlsm and create csv from master.xlsm on the path D:\results.

Sorry if i cannot make you understand better...

Thanks
farrukh

[farrukh]

Hi Watersev,

This code works for me but it is creating the .csv on path

C:\Documents and Settings\Administrator\My Documents

I want that the Csv file will create on the D:\results\

Thanks your help will be highly appreciated as you always help me

Thanks
farrukh

[watersev]

change this line:

Please Login or Register  to view this content.

to this one:

Please Login or Register  to view this content.

[farrukh]

Hi watersev,

Great it works for me,thank you so much for your kind efforts

Regards,
farrukh