>I want to see if I can do the following as an automated process:
>
> 1. I need to copy rows from sql server 2000 and paste them into excel
> worksheets.
> 2. Each of the 3 worksheets that contain data, also have an associated
> pivot
> table with them.
>
> Thus there are 3 detail woksheets and 3 pivot table worksheets that make
> up
> the workbook.
>
> I have tried to setup a macro script and let the script keep track of
> what
> I am 'keying in'. However after I close the excelspread sheet and send the
> excel
> spreadsheet to the user, the user can not read the excel spreadsheet. I
> know
> in excel if you set thge security level less than 'high', you can record
> the
> script. However I am told that the security level on the excel spreadsheet
> needs to stay high.
>
> Thus do you have any other suggestions on what I could do to automate this
> process?
>
> Thanks,

"Mike" wrote:

> I'm not sure about DTS but you can do this with .NET. If you have a
> developer in your area that knows .NET, this can definitly be done using
> that. I have an app that does almost this now, everything but the pivot
> table aspect of it.
>
> I do a query on the database and dumps the data into a workbook in excel
> "Wendy Elizabeth" <WendyElizabeth@discussions.microsoft.com> wrote in
> message news:D20871AE-EB21-40BA-A454-F52FA831A02E@microsoft.com...
> >I want to see if I can do the following as an automated process:
> >
> > 1. I need to copy rows from sql server 2000 and paste them into excel
> > worksheets.
> > 2. Each of the 3 worksheets that contain data, also have an associated
> > pivot
> > table with them.
> >
> > Thus there are 3 detail woksheets and 3 pivot table worksheets that make
> > up
> > the workbook.
> >
> > I have tried to setup a macro script and let the script keep track of
> > what
> > I am 'keying in'. However after I close the excelspread sheet and send the
> > excel
> > spreadsheet to the user, the user can not read the excel spreadsheet. I
> > know
> > in excel if you set thge security level less than 'high', you can record
> > the
> > script. However I am told that the security level on the excel spreadsheet
> > needs to stay high.
> >
> > Thus do you have any other suggestions on what I could do to automate this
> > process?
> >
> > Thanks,
>
>