no answer?

Hello,
I have a form which contains 2 lists (a combo and a list) in the combo
there would a column of an Excel sheet (without double) and according to
the selection in this combo, there would be posting of a list containing
the result of the filter.
In short, I seek a code to be able to post a table Excel (result of a
filter) in this list (columns and ranges)...

(Excuse for my english)
Thank you

 

Hi...

I don't understand you question. You speak Spanish? I yes.

 

No, french..

 

The reason, someone, like me, hesitates to post an answer to your question
is that your question raises a too big or too general issue here. It may
need quite a few minutes to give an understandable (to you, at least) reply.

I'll try to give you a brief hint.

1. You need figure out hoe to get data in Excel. The data to be retrieved
from Excel varies. depending on user's selection in the ComboBox. You can
either use ActiveX automation or DAO/ADO to access data in Excel sheet. In
your case, ADO is probably the better choice. You can either retrieve all
data at once, or retrieve only necessary for a single ComboBox selection,
depending on the amount of data and your app design.

2. Once you figure it out how to get data from Excel, you write event
handler to handle ComboBox_Click event. That is, when ComboBox is clicked,
you find useful data from already retrieved data, or you retrieve useful
data here, and then display in a control, say, ListBox

You can search Microsoft's knowledge base for how to use ADO with Excel
Sheet. There are quite a few articles/examples. When you run into difficult
in your coding, then someone may love to post back their answers to a
specific question