Help with the macro modification

[Nithya1987]

HI,

We have a macro which is being used for converting the xls files to csv files., I need to change the output filenames of the generated .csv.. right now it is generating the filenames as tabname_timestamp for all the tabs present in the xls.

But I am looking for the below naming convention..if my xls name is SEP012011_DollarU_load.xls which has tabs like Monthly , weekly, the macro should generate the files as

SEP012011_DollarU_load.xls_Monthly
SEP012011_DollarU_load.xls_weekly

below is the piece of code which I tried to modify for the above outcome.., but i was not able to even compile the code

Please Login or Register  to view this content.

And below is the macro which we are using .Please tell me how to add the xls name in the tempname variable so that the macro will generate the file formats as mentioned above.

Please Login or Register  to view this content.

Best REgards

[Nithya1987]

Hi,

I tried to get the xls_name_worksheet name as the script is generating a log file which has these details, but when I modify the tempname as below the filename is changing as required in the log file.., but the actual file is not changing.

Please tell me where is the issue.

Please Login or Register  to view this content.

Best Regards,
Nithya

[Nithya1987]

Hi,

Can any one pls give me a hint or tell me is there a function, if we use it it will give my the xls name for getting the desired file out put format.

Regards,
Nithya

[Nithya1987]

Hi ,

Figured out the problem and fixed.

Thanks for all your support.

Regards,
Nithya