Asked By
jamesfield
0 points
N/A
Posted on - 08/04/2011
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.
Answered By
kijingo
0 points
N/A
#97750
Microsoft Office Excel cannot access my file
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.
Microsoft Office Excel cannot access my file
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.
