Open Excel Pivot table with dynamic record source

[trito]

Hi,

What I am trying to do is open a pre-formated Excel Pivot table in an ADP form but limiting the data depending on the user. The idea I have is to create an Excel spreadsheet with pivot table as a template and use a command button to open the spreadsheet, change the record source (using either a recordset or sql statement), and refresh the spreadsheet. I've been searching for hours for examples on how to do this but all I found were examples for creating new files. I would appreciate any advice.

Thank you,

t.t.

 

[danvlas]

If you base your Pivot on the entire list spreadsheet (until roe 65535), that would do the trick...
Or I have misunderstood your question.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html