Consulting

Results 1 to 8 of 8

Thread: xlsm file opens and immediately closes

  1. #1

    xlsm file opens and immediately closes

    Hello there,

    I have an .xlsm file converted into .exe.

    Suddenly, when I open the file, excel application opens, then .xlsm file opens and immediately closes.

    I have the same issue with many similar .exe files and also hav tries to open them form several environments (win7, win8, win10, office 2010-2013-2016, 32bit, 64bit)

    Ive tried it in excel safe mode but again doesn't work.

    Any ideas?

    Thank you very much

  2. #2
    VBAX Expert Dave's Avatar
    Joined
    Mar 2005
    Posts
    832
    Location
    How did U convert it to a .exe file? If your having similar issues with other files, I'm guessing its your installation. HTH. Dave

  3. #3
    No unfortunatelly I didnt converted the files...
    i found them like this.
    All files where working and one day stopped working in different environments.
    I need the code of the xlsm files but its also too difficult to do reverse endineering.

    (Sorry for my english)

    Really thanks for your answer

  4. #4
    You say, "Suddenly, when I open the file, excel application opens, then .xlsm file opens and immediately closes"

    This leads me to believe that maybe there is a 'Application.Close' command at the end of the macro (closing the file once the subroutine has completed)...

    So try this.
    Disable macros in your settings... Then open the file.
    In theory, the macros won't run and hopefully the excel file will just stay there 'doing nothing'.

    If that works, then in theory, you'll be able to open up the VBA Editor (ALT + F11), and you'll be able to view the code.

  5. #5
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    I think the free-use trial period has expired.

  6. #6
    I really appriciate your answer but I already have tried disabling the macros in Excel.

    The same thing happens.

    Also the weird thing is that although the file is saved locally, if I try to open it with no connection to the internet I get a message from Excel: "Please connect to the internet and reopen the file" and file doesnt even open.

    Really weird...

  7. #7
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    @ snb,

    Sounds like it.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  8. #8
    VBAX Newbie
    Joined
    Feb 2020
    Posts
    1
    Location

    Lightbulb Workaround for Excel files abruptly crashing after opening.

    Quote Originally Posted by aniakpit57 View Post
    Hello there,

    I have an .xlsm file converted into .exe.

    Suddenly, when I open the file, excel application opens, then .xlsm file opens and immediately closes.

    I have the same issue with many similar .exe files and also hav tries to open them form several environments (win7, win8, win10, office 2010-2013-2016, 32bit, 64bit)

    Ive tried it in excel safe mode but again doesn't work.

    Any ideas?

    Thank you very much

    Hi,

    I had the same problem. I tried the following and resolved the issue.

    Make MS Excel operate in safe mode. Remember : This is not windows safe mode.

    To get excel open in safe mode, do the following :


    • Hold the windows key + Letter ‘R’ on the keyboard to launch the Run command > Copy and paste the following command line in the open box and click Ok.
    • Type : "excel /safe" without quotation marks.
    • click OK.

Posting Permissions

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