Exporting Excel Sheet with Radio Buttons

[CBB]

I need to export a number of spreadsheets into Access. These spreadsheets contain approximately 60 questions and the user responds by selecting the corresponding Radio Button. I need to capture the results and then perform searches based on the information within the spreadsheets

Currently it appears that upon exporting the results (Radio Button selections) do not feed over.

Any help would be appreciated

Thanks,

 

[John Nurick]

Hi CBB,

I'm not really familiar with using option buttons on Excel sheets, but
as far as I know you need to link each button (or each group of
buttons?) to a cell on the sheet and then import that range of cells to
Access. If the sheet was properly set up for the purpose there will
already be a range of linked cells that contain the answers ready for
collation. This may be on another sheet in the workbook, and/or it may
be a named range (which Access should list as an option in the
spreadsheet import wizard).

Alternatively, it's probably possible to write VBA code to iterate
through the option buttons (perhaps using the worksheet's Shapes
collection) and collect the values. If you want to do this, ask for help
in one of the microsoft.public.excel.* newsgroups.