Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15

Thread: Runtime Error '53' File Not Found

  1. #1
    Join Date
    23rd January 2007
    Posts
    8

    Runtime Error '53' File Not Found

    hi all,
    I wrote a program in Excel that calls a form to load when an action happens on a spreadsheet page, the code I used to call the form from is

    VB:
    sqe_portal.UserForm_Initialize 
    
    
    however since upgrading to MSoffice 2003 i get the runtime error '53' file not found. the files still their...? any ideas?

    Thanks.
    Mathew.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Runtime Error '53' File Not Found

    Mathew

    Why are you calling the userform's Initialize event?

    Why not just use Show?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,132

    Re: Runtime Error '53' File Not Found

    Can you post the full initialise code?
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  4. #4
    Join Date
    23rd January 2007
    Posts
    8

    Re: Runtime Error '53' File Not Found

    VB:
    Private Sub Workbook_Open() 
        sqe_portal.UserForm_Initialize 
    End Sub 
    
    
    will try it with show now.
    1 sec.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    23rd January 2007
    Posts
    8

    Re: Runtime Error '53' File Not Found

    nope.

    the show command brings up the same error.

    the code is in place to bring up the user form 'sql_portal' when the workbook is opened.

    is their another way I can get the form to load on startup?
    Mathew.
    Last edited by mathewjenkinson; January 24th, 2007 at 00:14.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Runtime Error '53' File Not Found

    mathew

    As Roy has requested can you post the code?

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    23rd January 2007
    Posts
    8

    Re: Runtime Error '53' File Not Found

    Quote Originally Posted by norie
    mathew

    As Roy has requested can you post the code?

    see post above,

    did you want the code to the following form? its a bit long...

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Runtime Error '53' File Not Found

    Mathew

    The code we need to see is the code for the Initialize event.

    That could be where the error is actually happening.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    23rd January 2007
    Posts
    8

    Re: Runtime Error '53' File Not Found

    Quote Originally Posted by mathewjenkinson
    VB:
    Private Sub Workbook_Open() 
        sqe_portal.UserForm_Initialize 
    End Sub 
    
    
    will try it with show now.
    1 sec.
    isnt that the code for the initalize event? I'm confused..?

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Runtime Error '53' File Not Found

    No it's not.

    That code calls the Initialize event, which is actually something I wouldn't recommend doing.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. File Not Found Error In Add-in
    By atjensen11 in forum EXCEL HELP
    Replies: 14
    Last Post: November 7th, 2006, 21:56
  2. File Not Found Error
    By Steve M in forum EXCEL HELP
    Replies: 8
    Last Post: August 2nd, 2006, 12:31
  3. VBA "Runtime error 53: File not found"?
    By landau in forum EXCEL HELP
    Replies: 1
    Last Post: August 1st, 2006, 16:03
  4. Replies: 2
    Last Post: November 3rd, 2005, 09:54
  5. runtime error 1004 macro not found
    By spnz in forum EXCEL HELP
    Replies: 6
    Last Post: November 16th, 2004, 04:29

Bookmarks

Posting Permissions

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