PivotTableExportToExcel - need to specify an Excel file name

K

Katie

When using the above with RunCommand in a Macro... is there a way to have it
specify the name of the Excel file that you want to have created? Right now
this exports my Access pivot table to Excel, but it just leaves me open in
Excel with a Temp file name.

Thanks
Katie
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Embed the same Excel multiple times 0
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Excel - Wich Function should I use? 1
Grouping Names in Mail Merge 0
Crating User Form to Add Names 1

Top