Excel 2003 upgrade

[ttcsbg]

What is this product on sale at the moment called 'Excel 2003 upgrade'?

I have a workbook written in excel 2002 which contains lots of vba
control elements and Visual Basic elements such as common dialog
objects (it took me 4 months to write!)
My problem is that my colleuges can't open it in excel '97, which is a
problem.
I've tried saving the book in '97 format but this doesnt solve the
problem.

Is there a product for sale that can update excel '97 to open workbooks
written in excel 2002?

Any help on this is muuuuch appreciated, otherwise it's 4 months work
for nothing!!
Thanks!
Craig

 

[Dave Peterson]

The file format for xl97 to xl2003 is the same.

Users of xl97 should be able to open any normal workbook saved in any of those
versions. (Yes, there may be functions/code that break, but that shouldn't stop
the users from opening the file.)

I'd start by having the xl97 user open excel in safe mode:
close excel
windows start button|run
excel /safe
(and hit enter)

Then file|open your workbook to see what happens.

Maybe it's the user's pc--maybe it's your file.

If you think your file is corrupted and xl97 can't open it...

Lots of people have praised OpenOffice.org for saving their data and code.
http://www.openoffice.org, a 60-104 meg download or a CD

There are commercial recovery services. I've never used it, but you might want
to check into:
http://www.officerecovery.com

And sometimes newer versions of excel can open files that older versions can't.
(And sometimes just different versions may work, too!)

 

[Harald Staff]

Hi Craig

Excel 97 open all kinds of Excel workbooks, it is not the question of file
format.

I see two problems here:
- Some of your VBA probably addresses properties and methods added after
version 97. That code will err and stop.
- You are using "additional controls" like the Cdlg. Welcome to Dll Hell my
friend. I believe this is the reason for the "won't open" problems.
Additional controls require that the user have them installed and often also
licenses to run then i "design time". Problem always.

Additional controls do add lots of useful functionality to Excel files, but
this is rarely the case with the Cdlg. What are you using it for ? If it is
file open/file save then workarounds are really easy and your four months'
work is out of danger.

HTH. Best wishes Harald

 

[ttcsbg]

Thanks for you're help guys much appreciated!
I think I will make a copy of my workbook and step by step remove the
VB functionality until it opens in excel '97 in order to trace the
problem. I'll keep you posted.
Cheers,
Craig