how to program in excel
 

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,

how to program in excel
 

Get a security certificate.


On Jul 2, 7:22 pm, Wendy Elizabeth
wrote:
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,

how to program in excel
 

Would each user that has access to the excel spreadsheet, would they need the
security certificate also?

Thanks,

"ilia" wrote:

Get a security certificate.


On Jul 2, 7:22 pm, Wendy Elizabeth
wrote:
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,

how to program in excel
 

Your spreadsheet will have a digital signature that tells Excel the
workbook is secure. It will be distributed with the spreadsheet.

This is only one option. It may not be cost-effective for you, but I
thought I'd throw it out there. You can find some info he
http://www.thawte.com/ssl-digital-ce...ing/index.html

You could also develop a simple application (as a stand-alone EXE)
that loads Excel, then has Excel load the workbook. I believe this
bypasses the security check, but will be trickier to implement. There
are also managed COM libraries applications for use with .NET
languages with Office applications, but .NET also has strict security
requirements.


On Jul 6, 5:10 pm, Wendy Elizabeth
wrote:
Would each user that has access to the excel spreadsheet, would they need the
security certificate also?

Thanks,



"ilia" wrote:
Get a security certificate.

On Jul 2, 7:22 pm, Wendy Elizabeth
wrote:
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,- Hide quoted text -

- Show quoted text -