+ Reply to Thread
Results 1 to 3 of 3

Convert Combo box Result/Selection to CSV File

  1. #1
    Registered User
    Join Date
    05-18-2009
    Location
    Auckland,NZ
    MS-Off Ver
    O365
    Posts
    14

    Convert Combo box Result/Selection to CSV File

    We are trying to import a Third party .XLS Excel file into a SQL database by converting Spreadsheet into CSV.

    However there are "combo boxes" that fail to supply the result. The field in the resulting csv file either ends up blank or listing ALL options on Combo Box List.

    Keen to hear if anyone has alternative solution to this problem.

    Thanks in advance

    Matthew

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Convert Combo box Result/Selection to CSV File

    Can you attach a sample of the xls and the csv.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Registered User
    Join Date
    05-18-2009
    Location
    Auckland,NZ
    MS-Off Ver
    O365
    Posts
    14

    Re: Convert Combo box Result/Selection to CSV File

    Sorry
    was away for a while.
    Please find attachment example

    Note: We will not be able to change attachment as comes from third Party

    Cheers

    Matthew
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Poplulating a second combo box based on user selection in first combo box
    By lateniteNC1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2017, 12:40 AM
  2. Replies: 19
    Last Post: 09-06-2014, 06:30 PM
  3. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  4. [SOLVED] Combo Box2 selections available based on Combo box 1 selection
    By wishn4fishn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2013, 08:13 PM
  5. combo box input range based on the other combo box selection
    By hedayet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2013, 02:27 AM
  6. Populate a Combo Box based on the selection of another Combo Box
    By thunder279 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2011, 03:40 PM
  7. Values of combo box dependent on selection in another combo box
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2008, 05:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1