EXCEL file cannot be accessed for Recalculation of worksheet via VB. - TechRepublic
Question
March 20, 2009 at 04:00 AM
civil_finesse

EXCEL file cannot be accessed for Recalculation of worksheet via VB.

by civil_finesse . Updated 17 years, 4 months ago

I have a Vb6 project I run. One of the forms called “APPROACHES” is connected to an Excel file called “APPROACHES”. Anytime I visit the APPROACHES form and give a command to open and calculate worksheet in the “APPROACHES” file, I receive the following Error message:

Run-time error ‘1004’
‘APPROACHES.xls’ cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only.

If I leave the “APPROACH” form to another and issue the same command from there I encounter no such problems. Any help from kind fellows?

This discussion is locked

All Comments