How to change Pivot Table external data source (MS Access Database)by VBA

Discussion in 'Access VBA Modules' started by John Chi, Jun 10, 2012.

  1. John Chi

    John Chi Guest

    Dear all,

    I have several pivot tables linked to a MS Access Database. And currently the MS Access Database has moved location, How can I update the link to MS Access Database by VBA?

    Thanks very much!
     
    John Chi, Jun 10, 2012
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.