VSTO Excel -- Urgent Help

[bruno_c]

I need to create some reports for the accounting people at work.
I have created a workbook with three different worksheets. Each of
those has a pivot table which connects to a database.
What I need to do is email this workbook to some people every monday
automatically and update the pivot tables before I email them.
This is the first time I work with vsto and I am stuck at this point.

Please any help will be great

 

[steven1001]

In case it helps, we have similar requirements but deliver it
differently. You can put the spreadsheet on the accounting users'
machines and allow the spreadsheet to connect to the database when it
is opened and aut-refresh the data.
Set >>Table Options >> Refresh on Open to 'on'. Then all they have to
do is remember to open it each Monday to see the up-to-date data ;-).
regards

 

[bruno_c]

Steven,
Thank you for your reply, but even though the solution you are
sugesting will make my life easier, it can not be user in my case
because most of the people move to different locations and they work on
different pc.
THerefore, I dont have just one station that I need to install those
reports.
I have been searching online for some stuff, and I read sth about the
server data scenarios. I am not too sure how that will work, if you
have any idea please let me know.

Thank You again
Bruno