Generate csv file from excel

Experts, Can you please help

I have a file with 4 columns and i need to generate csv file

Current Time Calls Wait Calls Ans Avg Wait
11/19/2014 23:16:03 1 2 3

On clicking a button it should refresh the excel (F9) and then generate a csv file.

There is always only 1 row.
This row has to be added to the csv, i.e. now when i click generate csv it should generate csv with 1 row, and after say 10 secs when i click generate again it should add the row to the existing csv, so csv will now have 2 records.

attached the file.

Appreciate your help.

Hi Raju, Have a look at the attached, Try to click button and let me know......



Regards

Naveen,
Thanks a lot!

This works much better than what i expected, however can you help me with adding a button that will generate a csv file with rows A1:D7, and a button that will reset this excel.

and if that csv already exists in the folder, its should overwrite.

Thanks

Here you go.....

Just you need to replace D:\naveen\ in the code with your path where you want this to be saved...

you can edit the code with ALT+F11

It works like a charm!

Thanks a lot!

Glad it helped you....



1. If your question is resolved, mark it SOLVED using the thread tools
2. Click on the star if you think someone helped you

Naveen,
out put file is adding blank rows, can you please help me fixing this.

Current Time,Calls Wait,Calls Ans,Avg Wait,Rand,
11/23/2014 11:44:54,1,2,3,0.130594494,
11/23/2014 11:44:54,5,8,12,0.523485452,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,
,,,,,

Try this... attached...

Thanks Naveen!