Results 1 to 5 of 5

Thread: &H8000FFFF error
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default &H8000FFFF error

    Hi!

    I have made workbook with userform with Excel 2010 and now im trying to open it with Excel 365 and get error &H8000FFFF. Can anyone help me how i would get my workbook work with Excel 365?

    -Late

  2. #2
    Board Regular
    Join Date
    Nov 2009
    Posts
    219
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: &H8000FFFF error

    Hi,

    open it with Excel 365 and get error &H8000FFFF
    Hi I have Excel 365, but I've never seen the error you reported


    If not, complete the description showing some detail I will pass

  3. #3
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,245
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: &H8000FFFF error

    Put the code below in a regular module

    Code:
    Sub Ontime2()
    Application.Ontime Now + TimeValue("00:00:05"), "myMacro"
    End Sub
    Sub myMacro()
    MsgBox "Try now"
    End Sub
    and in the workbook open event put as the first line
    Code:
    Call Ontime2
    Does the error appear?
    Does the msgbox appear?
    If no and yes respectively to the above can you now use the Userform?
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  4. #4
    New Member
    Join Date
    Oct 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: &H8000FFFF error

    Thanks. I tried to add those codes but i can't even save the file because the error and there also comes compile error: out of memory.

  5. #5
    New Member
    Join Date
    Oct 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: &H8000FFFF error

    And this workbook still works on another pc with office 2010

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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