Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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")

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    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

    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.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    Sorry, this is outside my scope.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    I understand, thanks anyway

  7. #7
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

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

    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.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •