Linked Excel Graph - how to update

[leok31]

I have a linked Excel graph in my form. The process I go though to update them is:
User clicks on button
Excel opens up
Procedure in Excel runs that updates the data and the graphs
Excel Closes
The user does not see any of that. This process works fine.
But the linked graph does not actually update in the Access Form.
To do that I run the following code:

Set ctl = Me!OLEUnbound_pream
   With ctl
      ' Enable control.
      .Enabled = True
      ' Set Locked property to False.
      .Locked = False
      ' Set Verb property to activate for editing, but not visible
      .Verb = acOLEVerbShow
      .Action = acOLEActivate
   End With

The problem I get is that once .Action = acOLEActivate is ran, Excel opens. I don't understand why it does that and how do I close it.

Thanks

 

[KenHigg]

This sure is a lot of work. Why not bite the bullet and learn how to manipulate the chart in Access. It's the same engine, just the excel wizards are better.

 

[leok31]

The Access graphs don't make any sense to me. It's like learning a who new package for a tool that very rarely gets used as is.

Anyway, I figured it out for anyone who is interested.
You need to the Verb in the Property Sheet to -3.
I haven't tested the other numbers, but that seems to work. Not sure why though.

 

[Old Man Devin]

Anyway, I figured it out for anyone who is interested.
You need to the Verb in the Property Sheet to -3.
I haven't tested the other numbers, but that seems to work. Not sure why though.

This list if for bound objects, but it might still apply here. Shows what all the different verb choices do!

http://msdn.microsoft.com/en-us/library/office/ff835064(v=office.15).aspx