From: Ralph-MN on
The option we use is to render (export) the report to a CSV file and have the
Excel file use the CSV file as a datasource. The Excel file can have
pivots/graphs, etc and the CSV file can be updated on a regular basis (i.e.
subscriptions) without interferring with the Excel file.

"OriginalStealth" wrote:

> REPORT A runs.
> MyFile is an Excel file that contains two tabs(Data and Names)
> The records in REPORT A correspond to the DATA tab in MyFile.
> Is there a way to export REPORT A and have it replace the information in the
> DATA tab and not overwrite the entire file? If so, a code example would be
> ideal but if you have a link that would be great also.
>
> Thanks in advance
>
> OS
>