Address AES Encryption to MS Excel (VB6, Excel 2K)

Topic

New Reply

I have a Visual Basic 6.0 front end app that talks to a Excel 2K spreadsheet. I found when trying to encrypt the spreadsheet I had the option for AES encryption, so I selected it. When opening the spreadsheet on the server I have no problem. When running my compiled VB front end it returns an error saying that the encryption type is unavailable and that this could be resolved using the MS High Encryption Pack. Since I can open the spreadsheet from the server I assume the server already has this. How do I get my VB app addressing it to open it. This is the line of code that instantiates the Excel object:

Set oXLWBook = oXLApp.Workbooks.Open(c:SpreadsheetName.xlt”, , , , “Password”)

Reply | Quote

Replies

You’ll probably have to install the high encryption pack for the appropriate Windows version on each PC running the front end. See for example Windows 2000 High Encryption Pack for download information.

Reply | Quote

Hans, thanks. I have it running in a Citrix session but the front end is on another server. I checked that server by trying to save a spreadsheet there with the same encryption and AES was not available. I will have to upgrade that server to resolve this.

Reply | Quote

(Edited by HansV to make URL clickable – see Help 19)

Hans, I loaded the High Encryption Pack on the server hosting the front end application from the following URL
http://www.microsoft.com/downloads/details…;displaylang=en[/url]

After rebooting the server it still gave me the same error message. Do you have any ideas? I know this is new ground I’m treading on.

Reply | Quote

Sorry, this is outside my scope.

Reply | Quote

I understand, thanks anyway

Reply | Quote

I understand, thanks anyway

Reply | Quote

Sorry, this is outside my scope.

Reply | Quote

Any chance you need to reference the CryptoAPI in your project in order to use it?? (A Google search didn’t point me to either a yes or no answer.)

Reply | Quote

Any chance you need to reference the CryptoAPI in your project in order to use it?? (A Google search didn’t point me to either a yes or no answer.)

Reply | Quote

(Edited by HansV to make URL clickable – see Help 19)

Hans, I loaded the High Encryption Pack on the server hosting the front end application from the following URL
http://www.microsoft.com/downloads/details…;displaylang=en[/url]

After rebooting the server it still gave me the same error message. Do you have any ideas? I know this is new ground I’m treading on.

Reply | Quote

You’ll probably have to install the high encryption pack for the appropriate Windows version on each PC running the front end. See for example Windows 2000 High Encryption Pack for download information.

Reply | Quote