Microsoft Office Excel cannot access my file

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.

• Status: Open
• Question Views: 2690
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Visual basic

Best Answer by pettymwas

Go To Solution

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.

About kijingo

Questions
1

Answers
12

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: Visual basic

Best Answer

Best Answer

Answered By pettymwas 0 points N/A #97752

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.

About pettymwas

Questions
0

Answers
11

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/04/2011
• Question Category: Visual basic