Connecting two macros: Refresh pivot data then export as PDF

Hi all:

I have a worksheet that has pivot data coming from an access database. I am trying to connect these two macros so that the workbook refreshes and then exports and saves the pdf. I've tried putting the export portion of the macro within the refresh, but when compiling I get the "expected end of sub" error. Any ideas? Thanks!

Please Login or Register  to view this content.

try this:

Please Login or Register  to view this content.

Hi IonutC:

Thanks for your response, but it doesn't do anything (i.e. refresh the pivot data or export the pdf).

Originally Posted by onemoremile

Hi IonutC:

Thanks for your response, but it doesn't do anything (i.e. refresh the pivot data or export the pdf).

Hi,

I just used your code. Pls attach your excel and will give it a try to help u.

Cheers,
Ionut