I have an Access (2007) table that I update with new parameters using SQL DoCmd. This table is linked to an Excel(2007) worksheet from which a pivot table (separate worksheet) and graph (separate worksheet) are created. The Excel graph has been linked back to an Access OLEUnbound object frame. I have been unable to automatically update the Excel worksheet link from Access VBA, after trying several approaches gleaned from the internet. I can open Excel and update manually, but all Access VBA attempts have failed. I consider myself a novice+ in the world of VBA.
Thanks in advance,