Information about Spreadsheet-control needed

[Volker Neurath]

Hi @ll,

I need information about how to control the Spreadsheet-control from within
Access-VBA

anybody out hiere who can give me a hint where i can find some reading ti
learn more about that control?

MSDN has nothing more than three(!) pages about it... which already won't
help me

Volker

 

[Bob Quintal]

Hi @ll,

I need information about how to control the Spreadsheet-control
from within Access-VBA

anybody out hiere who can give me a hint where i can find some
reading ti learn more about that control?

MSDN has nothing more than three(!) pages about it... which
already won't help me

Volker

Sample Excel Automation
http://www.mvps.org/access/modules/mdl0006.htm

Run Excel Macros through Automation
http://www.mvps.org/access/modules/mdl0007.htm

Transferring Records to Excel with Automation
http://www.mvps.org/access/modules/mdl0035.htm

 

[Volker Neurath]

Hi Bob,

thank you for your links, but that is not what I was looking for.

My colleague at work was explicitly asking me about the use of the MS
Spreadsheet-Control (MS Office Spreadsheet 11.0) for Access.

Allthough I will recomend him to use office automation, because on whole
the net I couldn't find anything about spreadsheet control but the
remark that standard-access- and excel-vba commands won't work.

Thank you so far.

Volker