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:
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.Code:Sub Arbitrage_Reset() Dim ArbPrj As New ArbCls ArbPrj.prjOpen ActiveWorkbook.FullName, ActiveSheet.name ArbPrj.Reset ArbPrj.prjClose ActiveSheet.Cells(1, 1).Select End Sub
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 17:03.
landau, please use Code tags for code not Quote.
If you simply opening a Workbook use
There are currently 1 users browsing this thread. (0 members and 1 guests)