Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Using SQL*XL in Excel 2007 (Read 10981 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Using SQL*XL in Excel 2007
25.01.07 at 22:03:22
 
Using SQL*XL in Excel 2007
 
SQL*XL, Excel 2007 and security.  
In Excel 2007 a couple of things have changed. Security for addins has changed and the interface too. This article helps you through the process of using SQL*XL in Excel 2007.
 
If the Thawte digital signature is not installed you may get the following warnings in Excel 2007:
"Microsoft Office Excel Security Notice"  
"Microsoft Office has identified a potential security concern"
"This content has a signature that has been altered after the content was signed. Do not trust this content."
 
 
Clicking on Show Signature Details shows the following screen and the warning:
"The certificate in the signature cannot be verified"
   
 
The warning: "The certificate in the signature cannot be verified" is a sign that the Thawte root certificate is not installed. You can install that using Start - All programs - SQL*XL 4 - Install Thawte Code Signing Root Certificate
 
 
 
Press on the Install Certificate button to install the Thawte root certicate. A wizard will start.Please take all default options.
 
When the Thawte root certificate is installed you may still get the following security warning:
"Microsoft Office has identified a potential security concern"
"The content signature is valid but you have not chosen to trust the entity that published this content"
 
 
The last warning: "The content signature is valid but you have not chosen to trust the entity that published this content" means that you have not yet pressed the button Trust All From Publisher. To have a look at SQL*XL you need to press the Trust All From Publisher or the Enable Macros button.
 
When you chose to view the digital signature now you can see it is validated ok:
"This digital signature is OK"
 
 
 
In Excel 2007 security settings can be viewed and changed in the Trust center.
Use the Office icon and click the Excel Options button.
In the list of Excel option categories you find the Trust center.
From there you can press a button to go to the Trust Center: Trust Center Settings.
 
In the Trust Center you can set the following options:
 
Trusted Publishers:
If you have used the button "Trust All from Publisher" (recommended) our digital signature is listed in the list of trusted publishers as shown in the trusted publishers section.
 
 
The trusted locations section. In this section you seem to be able to specify paths where files are also treated as trusted. I added the SQL*XL program directory to see how that would work. Note that I deleted our digital signature from the list of trusted publishers for this test. My finding is that that worked very well too. I recommend to either add our digital signature as trusted or to add the SQL*XL program directory as a trusted location.
 
 
 
The last area of the trust center I want to discuss is the Macro Settings section.
To use all features of SQL*XL effectively you need to tick the "Trust access to the VBA projects object model" option. SQL*XL supports macro recording. If you record a macro in Excel SQL*XL adds lines of code to the macro when you access a database. To enable SQL*XL to do this you need to tick this option.
 
 
After all this security, where did SQL*XL go?
The addin is shown in the Add-Ins tab. The menu is shown on the left in the menu commands section. The toolbar is available in the right section called Custom Toolbars.
   
Back to top
 
« Last Edit: 25.01.07 at 22:08:40 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Using SQL*XL in Excel 2007
Reply #1 - 14.06.07 at 14:00:14
 
Please note that a new version of SQL*XL was released in which an SQL*XL tab on the new Excel ribbon was created. SQL*XL is now properly integrated with Excel 2007.
 
Please see:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1176407093/0
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Using SQL*XL in Excel 2007
Reply #2 - 15.04.07 at 12:55:34
 
While testing I saw another version of the security warning dialog:
 
Microsoft Office Excel Security Notice
Micrisoft Office has identified a potential security concern.
 
Warning: This digital signature is invalid and cannot be trusted. The macros will be disabled.

 
What is actually causing the problem is that the digital signature in SQL*XL could not be verified. The Thawte root certificate is not installed yet. You can install that certificate from the SQL*XL program group in the start menu.
Back to top
« Last Edit: 15.04.07 at 13:01:37 by Gerrit-Jan Linker »  

2007_security_warning.gif

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1