Setting SourceDoc in VBA - Excel Chart

M

mrcasey

I have a report that links to a chart in excel. I'm tying to update the
SourceDoc by

ctl.Properties("SourceDoc") =
"\\fres0603\budman$\South\Progress_Report_Generator\Dashboard\Dashboard -
FTE.xls"

then

ctl.Action = acOLECreateLink

when the code is executed (right now in the open event of the report) I get
"The bound or unbound object frame you tried to edit doesn't contain an OLE
object"

Any suggestions? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting SourceDoc in VB 2
OLE or Image, Bound or Unbound? 1
Coding SourceDoc in unbound object frame 0
How to have an empty image if there is no filepath stored for it 0
Using SourceDoc and/or SourceItem Properties 0
code only works when run twice, why? 3
Change and refresh OLEObject showing Excel chart on Access form. 0
How to delete embedded Word object? 2

Top