M
mrcasey
I have a report that has various unbound objects linked to charts or pictures
in various excel spreadsheets. I need to be able to update these links every
time I do a new release based on a drive path. I've figured out how to change
the SourceDoc property to the correct path but I can't get the object to
update based on that new path. I've tried objectname.Action acOleUpdate and
various other methods but no success.
Any ideas?
in various excel spreadsheets. I need to be able to update these links every
time I do a new release based on a drive path. I've figured out how to change
the SourceDoc property to the correct path but I can't get the object to
update based on that new path. I've tried objectname.Action acOleUpdate and
various other methods but no success.
Any ideas?