Schedule the export of a pivot table

[#1]

Hi!

Can any one help me please ?

I have a qvw with a few tabs.  There is one  tab with a pivot table and a graphic.

My client has the need to export data from a pivot table to Excel, every month on a certain day and at a certain hour.

And the export shall be for a particular folder on pc.

Thaís in advance,

Sandra

[deepakk]

hi Sandra,

Attach is  a sample file for exporting to excel using macro. You can schdule the file using in windows scheduler .

You can input the date of a month on which it should export the file.

A tigger has been set on the postreload method.

You can use publisher or software like Npriting to do this job.

Let me knw if you have any queries on the same.

Deepak

[#3]

Hi Deepak,

You said "Attach is  a sample file for exporting to excel using macro. " !?!

Can you be more Explicit, please. I never did such kind of requirements.

They don't have publisher or Nprinting.

Thanks once again.

[deepakk]

Ops.. I missed the file.

I have attched it in this post

Deepak

[Anonymous]

hi Deepak, quick question how can i schdule this report exporting on a regular basis. mean do i need to click on the Test button always when i wanted to export the data or else can i create a task in Publisher. Once the exporting is done where is the destionation the exported data will land. My requirement is to send the table information to Email.  Please help me on this.

[deepakk]

hi vinay,

On post reload event , you can call this macro. but this will not work with server. You have to schedule you reload through batch file. You can set the path inside the macro where the excel file need to be saved.

Else you can use Nprinting which is a third party tool.  It has some easy way of scheduling the reports to excel and pdf.

I had never tried with publisher. I have either use batch file load and then run the macro or I have used Nprinting

Deepak

[Anonymous]

This Nprinting tool is that a free ware tool or they charge us. If you have any details on that can you please share on that.

[deepakk]

It has a price attach to it. I have attach a sample document on nprinting.

If you want to know more about the pricing details. You can drop you mail id to my mail box.

deepak.dk@technoforte.co.in

Deepak