Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: VBA "Runtime error 53: File not found"?

  1. #1
    Join Date
    1st August 2006

    VBA "Runtime error 53: File not found"?


    I am new to Excel VBA. I bought a book about VBA in Excel and tried to study the code which came with the book. However, when I try to run the macro, an error message occurred :" Run-time error '53': File not found".

    I then pressed the debug button and it went to the red line below:
    Sub Arbitrage_Reset() 
        Dim ArbPrj As New ArbCls 
        [COLOR="Red"]ArbPrj.prjOpen ActiveWorkbook.FullName, ActiveSheet.name[/COLOR] 
        ActiveSheet.Cells(1, 1).Select 
    End Sub 
    where the path of ActiveWorkbook.FullName is "c:\vba2000.xls". I tried to replaced ActiveWorkbook.FullName with the full path name, but problem still persisted.

    One strange thing is that I am using Office 2000 and Windows XP Simplified Chinese version. I ran the macro on another machine with Windows XP Japanese version + Office 2000, the same problem appeared. However, on a very old machine with Windows 2000 English version + Office 2000, the macro ran faultlessly. I asked a friend who was using Office 2003+ Windows XP Italian version to test the macro for me, he didn't have any problem.

    Does the problem have anything to do with the Asian OS system? I tried to format the HD and reinstall Win XP Chinese version, but the problem is still there.
    Last edited by Dave Hawley; August 1st, 2006 at 16:03.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003

    Re: VBA "Runtime error 53: File not found"?

    landau, please use Code tags for code not Quote.

    If you simply opening a Workbook use

    Workbooks.Open "c:\vba2000.xls" 

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 3
    Last Post: June 8th, 2004, 01:49
  2. repetitive "file not found" error
    By good4u in forum Excel General
    Replies: 14
    Last Post: October 28th, 2003, 21:19


Posting Permissions

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