> Hi,
>
> We have lots of DTS packages that output to Excel files. We would
> like to add custom properties to the Excel files, such as the (DTS)
> source of the file, DTS package version, Any global variables etc.
> This would help us to identify the source of a file that has
> circulated around the company a few times, been changed etc.
>
> Can properties of Excel workbooks be set in ActiveX?
>
> Many TIA,
>
> Red.
>

On 9 Apr, 11:24, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello Red,
>
> Not really sure I get this but here is what I think
>
> You want to add to the export from file X a number of new columns and they
> will contain things like Filename and Global Variable X
>
> ....
>
> Have I got this the right way round?
>

On 10 Apr, 21:20, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello Red,
>
> OK you will have to open up the Spreadsheet programmatically and insert those
> property values.
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>

> On 9 Apr, 11:24, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
>
>> Hello Red,
>>
>> Not really sure I get this but here is what I think
>>
>> You want to add to the export from file X a number of new columns and
>> they will contain things like Filename and Global Variable X
>>
>> ....
>>
>> Have I got this the right way round?
>>
> Not quite. Open up an excel workbook, File > Properties > Custom. You
> can add custom properties for the workbook. This is what I want to
> add.
>
> I can add data to the sheets themselves, which I sometimes do.
> However, users often delete columns and sheets that don't interest
> them. Properties would suite my needs a little better.
>
> Thanks,
>
> Red.
>