Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel do this or do I need a different program? | Excel Discussion (Misc queries) | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
excel program | Excel Discussion (Misc queries) | |||
Excel program | Excel Discussion (Misc queries) | |||
merging excel program with tdc finance program | Excel Programming |