VB error message 'file not found'

Question

Hi all, i wrote some macros with office 2000 on windows XP. Macros were simple with some user forms and they all worked well in XP. then i installed Windows 2000 Operating system with the same office 2000 product and copied the excel sheets. but when i try to open the sheets a VB message box appears and displays 'file not found' error and never opens the sheet, even with disable macros choice. no other error message exists neither which file is missing information!. could someone please point me why i get this error and what could be the possible reason? i may provide the excel sheet if someone wants to reivew. thanks for your helps in advance. Emre.

abach · Answer

It seems your path to Excel files has changed. In XP, it might have been C:\Documents and Settings\UserName\My Documents, but in Windows 2000 the user name may be different.

SidBord · Answer

This is a long shot, but does your workbook refer to any files that are in Personal.xls or any other workbook? I wondered if you have to set up a reference to another workbook.

Productivity Software

Was this post helpful?