Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Automation error

    Need help with this.
    I have a shared Excel spreadsheet that is saved as a binary file, *.xlsb, that gives an automation when I try to open it

    automationerror.JPG The file is a training record and has quite a bit of code attached.

    Does anyone know a work around so I can open the file. Once open I can run the debugger to try to determine the problem
    cheers

    Phil Carter

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Try holding the shift key as you double click the file icon to open it (Bypasses macros).

    HTH,
    Maud

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Tried it didn't work, same result.
    I have attached the file to see if you can get into itStaffTrainingRecords.zip
    cheers

    Phil Carter

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I managed to open it by converting it to Excel 2003 - attached.

    The code has been preserved and, as you will see, it opens with a "Type Mismatch" error. I expect you can track this down.

    HTH
    Attached Files Attached Files

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 651 Times in 593 Posts
    It opens fine for me with your measure of security which appears to be tied to the logged on windows user. I was able to bypass it by sidestepping macros with the shift key. You have your vbProject locked so I am not able to assist you with your code. Attempting to unlock it

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Bonriki.

    I disabled your startup macros so you can open it and play with the code.

    HTH,
    Maud

    Was this a test to see if your security could be beat?
    Attached Files Attached Files
    Last edited by Maudibe; 2015-12-01 at 22:42.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Thanks Martin
    No code and about 40 sheets missing
    cheers

    Phil Carter

  8. #8
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Thanks Maude
    No it wasn't a test I could not disable the start up code using the usual hold the shift key when opening, so couldn't get access to the code
    cheers

    Phil Carter

  9. #9
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I think the code IS there, but the VB project is locked.

Posting Permissions

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