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,