Microsoft Office Excel cannot access my file

Asked By 0 points N/A Posted on -
qa-featured

Hi guys, I have an application issue here in Visual Basic, I meet an error while working, the error message goes Run-time error ‘1004’, I pasted below the error message full text for your full view of the application issue.

Microsoft Visual Basic

Run-time error ‘1004’:

Microsoft Office Excel cannot access the file ‘C:\temp’. there are several possible reasons:

. The file name or path does not exist.

. The file is being used by another program.

. The workbook you are trying to save has the same name as a currently open workbook.

OK                          Help

 

This error message that was displayed on my screen let me think for a long time on how can I solved the error, I already check all the aspects the error message states, but I still get same error message, please share some ideas on how to solve this application issue, thanks a lot guys in reading my post.

SHARE
Best Answer by pettymwas
Answered By 0 points N/A #97750

Microsoft Office Excel cannot access my file

qa-featured

the vital files needed for your visual basic to run normally may have been destroyed by some virus; I would advice you to reinstall the program.

thanks.

Best Answer
Best Answer
Answered By 0 points N/A #97752

Microsoft Office Excel cannot access my file

qa-featured

Hey Pal! First you need to check the path of the file you are trying to access. Did you in any way design the VB application that is trying to access the file in another computer and you migrated it into your computer? If so, the earlier VB code was written to direct the application into located the said file in ‘C:temp’ folder. I would strongly advice that you try and move this application from your current location and paste a copy of it in the ‘C:temp’ folder and see whether anything changes and that the error disappears. Also, try and make sure that file indeed exists in this ‘C:temp’ directory. If you do not want to move or copy your application to the ‘C:temp’ directory, try and adjust the code to direct the application access the said file from your preferred directory. I hope this resolves your issue. Regards.

Login/Register to Answer

Related Questions