File will not open
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: File will not open

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a file (which shows as being 461K file, which is about right) that will not open.
    When I try to open it it asks the usual macro question (I have tried both "Y" & "N"), and it then the shows the microsoft folder icon being opened and pages being removed and thats it! The screen remains blank.

    What could be wrong?

    Thanks Robert

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does excel open up ?
    If so then try clicking on the Window
    command and select (If not dimmed out)
    Unhide window.....??


    Ivan

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try opening it without the auto_open macro. When you open the file hold the SHIFT key.

    The other open macro is the workbook_open macro. Before opening the file (If the SHIFT key method fails), in another file/workbook, paste the code:

    sub stopevnts()
    application.enableevents = false
    end sub

    run this (if the first solution doesn't help) and then open the file.

    I think events will be re-enable if you close Excel and restart. If you need them sooner, run:

    sub startevnts()
    application.enableevents = true
    end sub

    HTH. Cheers,

    Nate

    [ This Message was edited by: NateO on 2002-02-28 18:58 ]

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    [ This Message was edited by: rdorr on 2002-03-02 04:10 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello again,
    “Ivans" post and “Nate's” Shift Key option did not work.
    I have no expertise with VBA but I tried Nate's code option which did not work either but to confirm that I did it correctly I have listed below what I did (in Excel Office 97)
    Open "NewBook"
    Alt F-11
    "This workbook"
    right click and "insert"
    "New Module" (named stop evnts)
    typed code "application.enableevents=false"
    Exit to 'NewBook"
    Ran "Macro"
    Open "Problem File"

    Results same as in original post.
    Did I do everything correctly and for my own eduction, what was this code supposed to do?
    Any other suggestions?

    Regards..........Robert

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi ==

    I have answered this type of question many time, suggest check my profile and then view my posts, your find a few with other posts also, worth looking up.. Alos try search on this new board and old as i and many posted there also.

    HTH


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    New Member
    Join Date
    Jul 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: File will not open

    Quote Originally Posted by Jack in the UK View Post
    Hi ==

    I have answered this type of question many time, suggest check my profile and then view my posts, your find a few with other posts also, worth looking up.. Alos try search on this new board and old as i and many posted there also.

    HTH
    Hello Jack,
    I searched your postings for over 10 pages and could not detect anything related, could you please provide some search hints or, better yet a link?

    I have a 'workbook macro' that every second invokes and a macro in 'Module 1' to interrogate a dde.xls file to see if there are any updates. Suddenly when I open the Excel file I get a gray page with no spreadsheet, yet Window shows the file to be open and Tools/Macro/Edit allows me to see the Macros.

    What can I do in order to get the spreadsheet to become visible? (Windows/Unhide is grayed out).

    Thanks!

    Tom

    PS- I'm a novice with Excel Macros, using Excel 2000 on a Windows XP PC.

  8. #8
    New Member
    Join Date
    Jul 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Re: File will not open

      
    SOLVED! After fumbling for hours searching online I stumbled upon the answer:

    With the problem file "open" (i.e. just a gray page with no workbook visible, yet the file showing in Window as open and MyMacro accessible via Tools/Macro), this is what reinstated the worksheets to become visible:

    Window/Arrange ---> Then make sure "Windows of active workbook" is checked!
    _____________

    PS - How/why this program suddenly set itself to not show active windows I'll never know.

User Tag List

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
  •  

 

 
DMCA.com