open excel
 

hi

I have a problem to open old excel file which made in MS OFFICE 97

AT PRESENT I USE MS OFFICE 2000 STANDARD WITH WINDOWS 2000 PROF.

THIS EXCEL FILE IS STILL OPEN IN OFFICE 97
THE ERROR IS DEVICE I/O ERROR

open excel
 

Hi Ani,

I have a problem to open old excel file which made in MS OFFICE 97

AT PRESENT I USE MS OFFICE 2000 STANDARD WITH WINDOWS 2000 PROF.

THIS EXCEL FILE IS STILL OPEN IN OFFICE 97
THE ERROR IS DEVICE I/O ERROR

Sounds like a problem with a userform to me. Does the file contain any?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

hi there is no problem in disk i/o
the excel contain a good number of sheets
some containing macro


"Jan Karel Pieterse" wrote:

Hi Ani,

I have a problem to open old excel file which made in MS OFFICE 97

AT PRESENT I USE MS OFFICE 2000 STANDARD WITH WINDOWS 2000 PROF.

THIS EXCEL FILE IS STILL OPEN IN OFFICE 97
THE ERROR IS DEVICE I/O ERROR

Sounds like a problem with a userform to me. Does the file contain any?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

Hi Ani,

hi there is no problem in disk i/o

I know.

the excel contain a good number of sheets
some containing macro

Does any of the VBA project(s) contain userforms?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

hi JAN
yes
few of the sheets contain macro


"Jan Karel Pieterse" wrote:

Hi Ani,

hi there is no problem in disk i/o

I know.

the excel contain a good number of sheets
some containing macro

Does any of the VBA project(s) contain userforms?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

Hi Ani,

yes
few of the sheets contain macro


If you select all worksheets (click first, hold shift and click last
tab) and copy them to a new workbook (rightclick tab, select move or
copy, choose "New workbook" from the dropdown) and save that new file
(use a different name!), does the problem go away?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

Hi Jan

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel



"Jan Karel Pieterse" wrote:

Hi Ani,

yes
few of the sheets contain macro


If you select all worksheets (click first, hold shift and click last
tab) and copy them to a new workbook (rightclick tab, select move or
copy, choose "New workbook" from the dropdown) and save that new file
(use a different name!), does the problem go away?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

Hi Ani,

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel


Check out this article:

http://www.jkp-ads.com/articles/CorruptFiles.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

open excel
 

Hi Ani,

Try this

Go to start-run.Type excel /safe.This opens excel in safe mode without any
startup addins or macros which might run as soon as the workbook opens.Try
to open your 97 excel file from here.If it opens successfully save it as a
Microsoft
excel 97/2000 file.Plz lemme know if this helps.

Rgds,
Ambrish

"Jan Karel Pieterse" wrote:

Hi Ani,

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel


Check out this article:

http://www.jkp-ads.com/articles/CorruptFiles.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com