Results 1 to 1 of 1

Thread: Convert excel into csv file by clicking a button

  1. #1

    Convert excel into csv file by clicking a button



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	screen shot 1.jpg 
Views:	13 
Size:	97.1 KB 
ID:	1698   Click image for larger version. 

Name:	screen shot 2.jpg 
Views:	10 
Size:	97.6 KB 
ID:	1699   Click image for larger version. 

Name:	screen shot 3.jpg 
Views:	7 
Size:	97.6 KB 
ID:	1700  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •