Excel?

Discussion in 'AutoCAD' started by media, Mar 1, 2004.

  1. media

    media Guest

    Hi,
    In a VBA form I have a button, a combobox and a list, I want to have:
    - the button allowing me to select an Excel file in the disc,
    - the combobox for to have the list of the sheets existing in the Excel
    file
    - the list for to have the contents of the selected sheet.

    Can somebody help me? code on the Net?

    thank you for your always efficient assistance.
     
    media, Mar 1, 2004
    #1
  2. media

    Mike Tuersley Guest

    For the second part, you would need an Excel viewing component. You could
    try to locate a freeware viewer control that displays Excel, or locate a
    freeware grid control and populate it with the Excel data. Would be a lot
    easier than reading the entire spreadshheet and populating a listox -
    listview would be more appropriate anyway.
     
    Mike Tuersley, Mar 2, 2004
    #2
  3. media

    media Guest

    VBA does'nt recognize the function: ShowFileDialog !!!
     
    media, Mar 5, 2004
    #3
  4. media

    Jeff Mishler Guest

    It's in the zip file he attached that you need to include in your
    project......
     
    Jeff Mishler, Mar 5, 2004
    #4
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. Starting Makro in Excel

  2. add a new line to an existing excel file

  3. passing an array of values to an Excel range with vlisp

  4. ??How to connect to MS Excel through Visual Lisp?????

  5. Reading Excel File without starting Excel ?

  6. Retrieved Excel Cell values containing Excel Formulas are returned Empty.

  7. Attribute to excel and excel to attribute?

Loading...