spreadsheets

[Guest]

I am trying to use a spreadsheet object within a form. My goal is to write
scripts, activated by buttons that will allow me to read data out of queries
into the spreadsheet, edit it, and write the content of the spreadsheet out
to the appropriate tables.

-What VBA commands are available for reading and writing to a spreadsheet
found within a form?

 

[Guest]

You can embed an excel object in a form but do the processing offlline.
Meaning you unbound the object when it;s saved and then open in code an
excel object which you will use to open the file and parse for amended values.

i'm not sure whether you can directly access the embeded object on the form
so that's to be tested.

- Raoul