Question 2: automatically update an embedded XLS-flie

[jan Veenstra]

Hi,

I am having two problems with Access 97. These 2 problems are posted
seperately in this newsgroup. Here's the second (and probably the
easiest):

I can create an embedded excel file in a form but how can I update the
contents of the embedded excel file (in a worksheet) with the outcome of
a query? How can I update it by using VB? I want touse that outcome to
create an excel-graph. I can also do this by creating an Microsoft Graph
97 Chart, but this is not as flexible as I want it to be.

Thanks! Jan Veenstra

Answers can be placed in this group.
If you would like to mail me: replace the zero.
--
..