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?

--
Diane

The way I usually start writing a macro that extracts data from access is by
using a record macro and then manually go through the operations to extract
the data. Then I modify the macro to make it more general purpose.

1) Worksheet menu - Tools - Macro - Record Macro
2) Worksheet menu - Data - Import External Data - New Database Query - MS
Access Database
3) Then run a query.
4) Post macro that is generated by Excel so we can help modify the macro as
necessary.

"DianePDavies" wrote:

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?

--
Diane