I see that this question is not so liked
http://www.access-programmers.co.uk/forums/showthread.php?t=34660&highlight=chart+word
http://www.access-programmers.co.uk/forums/showthread.php?t=34660&highlight=chart+word
http://www.access-programmers.co.uk/forums/showthread.php?t=34660&highlight=chart+word
There are some references to MS Knowledge base but that has not helped me.
I want to send a chart either report or on a from directly to word.
I have found a copy/past method but cannot get it to work
It must be my limited experience with charts and access. If my set ctl is correct then I have a problem with the SetFocus as Access says I cannot do this.
How can I fix this?
Or does anyone have another suggestion of inserting a chart directly into word.
http://www.access-programmers.co.uk/forums/showthread.php?t=34660&highlight=chart+word
http://www.access-programmers.co.uk/forums/showthread.php?t=34660&highlight=chart+word
http://www.access-programmers.co.uk/forums/showthread.php?t=34660&highlight=chart+word
There are some references to MS Knowledge base but that has not helped me.
I want to send a chart either report or on a from directly to word.
I have found a copy/past method but cannot get it to work
Code:
stDocName = "frm_ClaimChart"
DoCmd.OpenForm stDocName
Set frm = Forms!frm_ClaimChart
Set ctl = Forms!frm_ClaimChart.OLEUnbound0
frm(ctl.Name).SetFocus
DoCmd.RunCommand acCmdCopy
With wd
.Visible = True
.Documents.Add
.Selection.PasteSpecial False, wdPasteOLEObject, wdFloatOverText, False
End With
Set wd = Nothing
It must be my limited experience with charts and access. If my set ctl is correct then I have a problem with the SetFocus as Access says I cannot do this.
How can I fix this?
Or does anyone have another suggestion of inserting a chart directly into word.