D
DianePDavies
I want to extract data from a large number of identical spreadsheets. I have
written a program in Access that can extract values from specified cells in
an Excel-file.
I want to specify the Excel-cells in a semi-automated way - to avoid manual
errors. I want to generate a list of field name and data cell. The "field
name" is typically a label in a cell next to or above the "data cell" with
the data value. So my list should look like e.g.:
Car Make, B2
Engine Size, B3
Wheel Distance, D2
Tank Volume, F12
....
Ideally I want to generate the list by selecting (double clicking) the cell
with the "field name" and then the cell with the data value.
If I simultaneously could see how my list is made - that would be really
good - i.e. have another window where I can see the selected values be
inserted - that would add to the quality! The list should idealy be in Access
- as my program then could use it directly.
So - How do I make a routine where I select cells and generate my list?
written a program in Access that can extract values from specified cells in
an Excel-file.
I want to specify the Excel-cells in a semi-automated way - to avoid manual
errors. I want to generate a list of field name and data cell. The "field
name" is typically a label in a cell next to or above the "data cell" with
the data value. So my list should look like e.g.:
Car Make, B2
Engine Size, B3
Wheel Distance, D2
Tank Volume, F12
....
Ideally I want to generate the list by selecting (double clicking) the cell
with the "field name" and then the cell with the data value.
If I simultaneously could see how my list is made - that would be really
good - i.e. have another window where I can see the selected values be
inserted - that would add to the quality! The list should idealy be in Access
- as my program then could use it directly.
So - How do I make a routine where I select cells and generate my list?