Export a straight or pivot table to CSV through a button object

[brijesh1991]

Hi,

If user wants to export a straight table or pivot table into CSV format, then user have to right click onto the object and then select the file type-CSV and give file name, then user can export table into CSV format.

But on front end, I want to create a button. User will click on it which will enable user to export the table (straight table id: Ch03) into CSV format by just clicking on it.

All ur ideas are warmly welcomed. . .

Regards,

BRIJESH

[#2]

Hi my friend.

Thanks a lot for the update. It is OK.

Regards

Alberto

[ashfaq_haseeb]

Welcome

Regards

ASHFAQ

[#4]

Hi Mohammed.

Once again me.

the Macro runs correctly on many LapTops. But on someone when the Macro stars this erroror appears:

============

Macro parse failed. Functionality wa lost

Maros Name

Error: ActiveX component can't create object: 'Excel.Application'

============

Do you have any suggestions on what to do to fix the issue?

Thanks a usual & regards

Alberto