Convert excel into csv file by clicking a button


New member
Sep 30, 2013
Reaction score
Hi all, may i know can the following be done? Please refer to the attached screen shots.

I have attached 3 screen shots.

Screen shot 1:
I have a combo box in a workbook named “Book1” with 2 options: ABC Market and CDF Market, and 2 buttons to convert to csv file. I open another workbook named “for screenshot”. When I click on the button “Convert to csv file (profiled)”, a csv file is created with the filename using the computer system time with the seconds that can be editable by the user, probably fixed the last two numbers which is the seconds to default number 00 or 01 whichever.
The “Convert to csv file (profiled)” button is used to create csv file with the status of “Profiled”.

Screen shot 2:
Work the same way as Screen shot 1 except user choose another option of CDF Market.
Screen shot 3:
User click on the button “convert to csv (all)” will create a csv file with all the status (Actual and Profiled)
I find it very challenging and I would be appreciated if anyone could help me on this. Thank you in advance for any help provided.


  • screen shot 1.jpg
    screen shot 1.jpg
    97.1 KB · Views: 17
  • screen shot 2.jpg
    screen shot 2.jpg
    97.6 KB · Views: 14
  • screen shot 3.jpg
    screen shot 3.jpg
    97.6 KB · Views: 10