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

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

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

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

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

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