Excel Runtime Error 13 (1 Viewer)

Albert Dicosta

Registered User.
Local time
Yesterday, 23:14
Joined
Sep 7, 2018
Messages
16
When I try to access Excel, I have encountered an error: “Excel Runtime Error 13”. So, to fix this error I have tried inbuilt Excel tool “File Recovery” mode. But still same error occur.

I have searched this query over this forum but didn’t find solution:
https://www.access-programmers.co.uk/forums/forumdisplay.php?f=55

After searched over Google, I have found few resources:


But, I still have no clue. URGENT HELP!
 
Last edited by a moderator:

isladogs

MVP / VIP
Local time
Today, 06:14
Joined
Jan 14, 2017
Messages
18,186

Gasman

Enthusiastic Amateur
Local time
Today, 06:14
Joined
Sep 21, 2011
Messages
14,048
Excel Runtime Error 13 appears to be Type mismatch error?

Open Excel and then open the file from within Excel holding the shift key down until it loads then investigate the code.

HTH
 

amans15877

New member
Local time
Yesterday, 23:14
Joined
Sep 11, 2018
Messages
4
You can use the following steps to help you tackle any Type mismatch error.

Run the code so that the error appears.
1. Click Debug on the error dialog.
2. Select View->Watch
3. Highlight the variable to the left of the equals and drag it into the Watch window.
4. Highlight everything to the right of the equals and drag it into the Watch window.
5. Check the values.
 

Users who are viewing this thread

Top Bottom