Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FYI - Illegal Operation (concerning forms) (2000)

    Just FYI,

    I have twice locked up a file with the illegal operation message after adding a button to a form (I think). After trying all else, I set the security settings to high and disabled all macros. I then opened the VBA project and deleted (and exported) the form I thought that might be causing the problem. I then imported the forms back, saved, closed, and reopened and all seems well.

    Out of curiosity, does anyone know what specifically occurs when you export a form, other than creating a form specific file with a .frm extension? What happens to the buttons, captions, and other controls? Are these stored as numerical settings within the .frm file? I would be interested to understand the process.

    Thanks,

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: FYI - Illegal Operation (concerning forms) (2000)

    Michael,

    When you export a Userform you actually create 2 files, one with a .frm extension and one with a .frx extension - known as the OleObjectBlob . The file with the .frx extension stores details of the controls and other OLE stuff, in binary format (I think). The .frm file is useless without the .frx file. It just stores the form screen metrics etc.

    It is interesting that exporting and re-importing the form seems to have sorted out your problems. There must have been some form of corruption in the form.

    Andrew C

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FYI - Illegal Operation (concerning forms) (2000)

    I thought it was pretty interesting too...I think my ones are mutating into zeros and vice versa while I sleep.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FYI - Illegal Operation (concerning forms) (2000)

    Hi Michael,

    Have you ever tried using my Autosafe utility?

    find it at

    http://www.bmsltd.ie/mvp
    (near bottom of page)

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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