T
Tony
Hi,
I have a spreadsheet saved as an xlt.
It has three pivot tables which connect to CSV data files using Microsoft
Text Driver.
The CSV files are updated overnight by an external application.
The Excel file is in \\Server\Viewers
The Data files are in \\Server\Data
Local users use a shortcut to open the Excel file on \\Server\Viewers which
the does an auto-update from the CSV files.
The pivot table data is updated.
All that has been working perfectly for years, internally.
Now I need to send the same excel file to another company by email.
I have succeeded in writing a vbscript that creates a message body and sends
the message and the excel file via SMTP.
Q.1. Does the Excel file do an autoupdate before being sent ?
Q.2 If not, how can I force it to autoupdate itself so the mail recipient
will have the updated version of the data.
I supposed I could get the vbscript to open the file and go into each Pivot
table and do a Refresh (F9), but is there an easier way ?
TIA
Seamus
I have a spreadsheet saved as an xlt.
It has three pivot tables which connect to CSV data files using Microsoft
Text Driver.
The CSV files are updated overnight by an external application.
The Excel file is in \\Server\Viewers
The Data files are in \\Server\Data
Local users use a shortcut to open the Excel file on \\Server\Viewers which
the does an auto-update from the CSV files.
The pivot table data is updated.
All that has been working perfectly for years, internally.
Now I need to send the same excel file to another company by email.
I have succeeded in writing a vbscript that creates a message body and sends
the message and the excel file via SMTP.
Q.1. Does the Excel file do an autoupdate before being sent ?
Q.2 If not, how can I force it to autoupdate itself so the mail recipient
will have the updated version of the data.
I supposed I could get the vbscript to open the file and go into each Pivot
table and do a Refresh (F9), but is there an easier way ?
TIA
Seamus