Pivot Table in Access to excel

[Amileaux]

Once I've created a pivot table in access, when I click the edit button, if excel is not already open, it will cause an error. So - two questions:

1. when I "automate" this for other users I need to check to see if they have excel open already, if not I need to open excel, then open the pivot table

2. since I'm not sure if multiple users can access the same pivot table - I want to force them to save the pivot table off as an export - but they will need to refresh. Is there a way to refresh the pivot table before it leaves access?

Thank you Marie

 

[Corticus]

Hi Amileaux,

1. when I "automate" this for other users I need to check to see if they have excel open already, if not I need to open excel, then open the pivot table

Try:
http://www.mvps.org/access/api/api0007.htm

2. since I'm not sure if multiple users can access the same pivot table - I want to force them to save the pivot table off as an export - but they will need to refresh. Is there a way to refresh the pivot table before it leaves access?

Try:
http://216.92.17.166/board2/viewtopic.php?p=213247&highlight=pivot#213247

Let me know if this does it for you...

HTH,

 

[Amileaux]

Thank you! I haven't worked through it yet - but I will! Marie