Q: Working with Embedded Excel Worksheets

[pinkpanther]

Sorry to have to ask this, but I’ve been digging through the group and
can not seem to find a solution to my situation.

I’m collecting some process data via OSI PI’s PI Data Link (for
Excel). However I’m storing more data than Excel could ever handle,
so I’m pulling this data into an Access Database. I have no problem
getting the data from an external Excel worksheet using linked
tables. However I have to continually open the worksheet, change the
starting date, save and close the workbook. I have managed to develop
a macro to do most of this work for me.

However I would like to move away from having a separate worksheet for
doing this task. I have successfully created an Excel Worksheet
Object on an Unbound Form in Access that will get my data from OSI PI.

Now I need the ability to change the Start Date cell on the Excel
Worksheet Object from an Access macro or VB module and then capture
the appropriate cells into my Access table.

Any help with manipulating data in an embedded Excel Worksheet Object
would be greatly appreciated.

Thanks,
Larry

 

[a a r o n . k e m p f]

you should get rid of embedded ole objects.. and move to the 'Office
Web Component'

It gives a lot better performance / stability, and you can definitely
link it to data quite easily

 

[pinkpanther]

you should get rid of embedded ole objects.. and move to the 'Office
Web Component'

It gives a lot better performance / stability, and you can definitely
link it to data quite easily

How do I do this?