"Microsoft Office SpreadSheet 11.0" inside the Access Form

G

Guest

Well, I want to know how to use the OLE Object "Microsoft Office SpreadSheet
11.0" inside the form. Basically I want to link a query on the Spreadsheet. I
only know to do this, accessing the OLE by VBA and using the property Sheets
with range, cells, offset...(doing the same thing as in Excel), but with this
knowlegde, I would do this using loop, recordset...(Maybe there would be more
errors on programming).
I want to know if there are suggestions about it (or how to use the command
'command and options' from the spreadsheet.)
Is there any material or site explaining this OLE Object?
Thanks for the attention.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Office Spreadsheet 11.0 Control 4
Error message about OLE/DDE links 2
Connected from Excel to Access 3
On Current Expression error 1
Problem with displaying images in forms 2
Link to Spreadsheet problem 3
Problem with images in forms 7
Error 429 on opening Outlook 2007 from Access 2003 1

Top