PivotTable Form

F

Florence

Dear all,

I have Macros with "OpenForm" action that can open a PivotTable form. Then
user will select "Export to Microsoft Office Excel" from the menu to export
the resultset to the Excel in HTM format as defaulted. They need to select
"Save As" to get the XLS file.

Is it possible to simplify this process that export a PivotTable form to XLS
format directly in either Macros or VBA ways?

Thanks for your help in advance!
 

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

#N/A values when exporting PivotTable to Excel 0
PivotTable: Type Mismatch 0
Imbeded Macro to Export To Excel Problem 0
Problem of PivotTable Form Export to Excel 0
Need to export multiple files 3
filtered form to export to excel and excel row format as text 0
VBA - synchronize multiple pivottable pagefilter 0
Form Button Opens as DataSheet not PivotTable 1

Top