how to program in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Would each user that has access to the excel spreadsheet, would they need the
security certificate also?

Thanks,
 
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 here:
http://www.thawte.com/ssl-digital-certificates/code-signing/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.
 
Back
Top