Access cell values from a spreadsheet control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form with a spreadsheet control. I use this to copy a set of cells
from a standard excel spreadsheet. I have a table that I want to put the data
in. I would like to create a macro that copies the data from the spreadsheet
control and puts it in the appropriate form fields.

How do I access the cell values via VB? e.g. "Field1.Value = Spreadsheet0. ? "
 
Rayo K said:
Hello,

I have a form with a spreadsheet control. I use this to copy a set of
cells
from a standard excel spreadsheet. I have a table that I want to put the
data
in. I would like to create a macro that copies the data from the
spreadsheet
control and puts it in the appropriate form fields.

How do I access the cell values via VB? e.g. "Field1.Value = Spreadsheet0.
? "
Click to expand...

Use the linked table manager to link to the spreadsheet and then read the
data from the linked table as you would any other. No code required.

HTH - Keith.
www.keithwilby.com
 
Back
Top