Refreshing a link to an object?

K

Kjell

Hi,
I have used the build-in Access tool to link a graph, created in Excel, to
an Access report. This graph is frequently modified. When I move the Access
application, and the corresponding Excel file, to another computer it looks
like that I have to re-establish the above mentioned link. I have the
VBA-source code but the intention is that the end user shall run an .mde-file.
Can I add some code, that is executed whever needed, that re-establishes the
link to the graph?

Greatful for any help!
Access 2002 and Excel 2002
 
Top