Automation from Access to 2 Excel Chart Titles...

[Bob Barnes]

Access code, after automation, includes...(IPFile is a concatenated string
including dates)..

M = "The Excel File" & vbCrLf
M = M & IPFile & vbCrLf
M = M & "Is Now Ready." & vbCrLf & vbCrLf
M = M & "Open " & Chr(34) & IPFile & Chr(34) & " ??"
O = "Open " & Chr(34) & IPFile & Chr(34) & " ??"
Resp = MsgBox(M, vbQuestion + vbYesNo + 0, O)
If Resp = vbYes Then Application.FollowHyperlink IPFile, , True

The Excel File has Auto-Open code to set Chart Titles on 2 Charts which
include $$$ summing data brought in via automation.

NOTE..When opening w/ the Application.FollowHyperlink, the
2nd Chart is NOT recalcing the 2 $$ values for the 2nd Chart.

The Total $$$ DOES calculate properly for the first Chart.

However, opening the Excel file "manually" DOES calculate the
2 $$ values for the 2nd Chart.

TIA - Bob