ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Fatal Error when opening Excel with Version 2002 only (https://www.excelbanter.com/excel-programming/385687-fatal-error-when-opening-excel-version-2002-only.html)

Alex St-Pierre

Fatal Error when opening Excel with Version 2002 only
 
Hi,
I have modify the program and thereafter, I was unable to open the excel
file from Excel 2002. Gives an error and need to recuperate the document(I
refused). Then, I tried to open it with Excel 2003, save it and all works
good. After doing that, I can open it in Excel 2002 but if I save the program
into Excel 2002, I can't reopen it with Excel 2002. So, I need Excel 2003 to
reopen it and ....
Why saving the file in Excel 2002 create an error. Does my file is corrupted
or does a way to know what is the problem ? Is it the VBA code that can
produce this kind of error ?
Thanks
Alex
--
Alex St-Pierre

JLGWhiz

Fatal Error when opening Excel with Version 2002 only
 
Does not sound like a corrupt file. Sounds more like a version or library
problem. If there are no error messages, it is probably a version glitch of
some type.

"Alex St-Pierre" wrote:

Hi,
I have modify the program and thereafter, I was unable to open the excel
file from Excel 2002. Gives an error and need to recuperate the document(I
refused). Then, I tried to open it with Excel 2003, save it and all works
good. After doing that, I can open it in Excel 2002 but if I save the program
into Excel 2002, I can't reopen it with Excel 2002. So, I need Excel 2003 to
reopen it and ....
Why saving the file in Excel 2002 create an error. Does my file is corrupted
or does a way to know what is the problem ? Is it the VBA code that can
produce this kind of error ?
Thanks
Alex
--
Alex St-Pierre


Alex St-Pierre

Fatal Error when opening Excel with Version 2002 only
 
If I open the file and disable macro, the file open correctly.
What I see is that the file space is about half the size file of the
original file. Is there a reason why since the file is complete?
Thanks!
Alex
--
Alex St-Pierre


"JLGWhiz" wrote:

Does not sound like a corrupt file. Sounds more like a version or library
problem. If there are no error messages, it is probably a version glitch of
some type.

"Alex St-Pierre" wrote:

Hi,
I have modify the program and thereafter, I was unable to open the excel
file from Excel 2002. Gives an error and need to recuperate the document(I
refused). Then, I tried to open it with Excel 2003, save it and all works
good. After doing that, I can open it in Excel 2002 but if I save the program
into Excel 2002, I can't reopen it with Excel 2002. So, I need Excel 2003 to
reopen it and ....
Why saving the file in Excel 2002 create an error. Does my file is corrupted
or does a way to know what is the problem ? Is it the VBA code that can
produce this kind of error ?
Thanks
Alex
--
Alex St-Pierre


Alex St-Pierre

Fatal Error when opening Excel with Version 2002 only
 
When I go to Visual Basic and save the project, the file space has taken 600k
to return to his original value! I don't know why? Does the error can be
related to excel file space?
Thanks!
Alex
--
Alex St-Pierre


"Alex St-Pierre" wrote:

If I open the file and disable macro, the file open correctly.
What I see is that the file space is about half the size file of the
original file. Is there a reason why since the file is complete?
Thanks!
Alex
--
Alex St-Pierre


"JLGWhiz" wrote:

Does not sound like a corrupt file. Sounds more like a version or library
problem. If there are no error messages, it is probably a version glitch of
some type.

"Alex St-Pierre" wrote:

Hi,
I have modify the program and thereafter, I was unable to open the excel
file from Excel 2002. Gives an error and need to recuperate the document(I
refused). Then, I tried to open it with Excel 2003, save it and all works
good. After doing that, I can open it in Excel 2002 but if I save the program
into Excel 2002, I can't reopen it with Excel 2002. So, I need Excel 2003 to
reopen it and ....
Why saving the file in Excel 2002 create an error. Does my file is corrupted
or does a way to know what is the problem ? Is it the VBA code that can
produce this kind of error ?
Thanks
Alex
--
Alex St-Pierre



All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com