Software

Ask something
Question Locked

Excel 2007 Compatability

0 helpful
2 replies

by galgon

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Our company uses many visual basic functions and subroutines with Excel. Most were written to move us from TurboBasic to Excel 2003 (a massive effort)

Excel 2007 (in compatability mode) doesn't seem to recognize these functions regardless of simply opening a 2003 spreadsheet or importing the .bas module.

When I convert the spreadsheet most of the functions work, though there is compatability comflicts with simple MW** declarations.

Unfortunately how do I share my work with the remainder of the company, let alone customers who rely on our engineering.

2007 also seems a little slow to open files.

Working on PCs since 1982...tired of learning how to do the same thing a different way and having to pay for it.

2 replies

by oh smeg

Is to continue to use Office 2003 as Office 2007 isn't a Update but a Completely New Product that was developed to replace 2003.

It is not Backward Compatible with a lot of the Special Items that where used with the Older Versions of Office when it comes to Scripts so you can either continue to use the existing Applications to do your work or invest a bulk load of money and redeploy all of your Specialized Changes to work on Office 2007.

Using M$ products was never supposed to be the Cheap Alternative and with them doing things like this it is down right expensive for most Businesses.

OH and BTW if you redevelop all your Existing Scripts and so on to work with 2007 it is quite likely they they will not work with Older Versions of Office even if you remember to save the Files in the Old Formats and not their Native Formats so if you where to attempt to share these documents with people using older versions of Office they are unlikely to work properly.

It's also Bad Manners to expect people particularly Customers to have to install items of Software on their systems to read your Documents. Many will simply find new suppliers to source their needs from hen this happens.

Col

This discussion is closed to new replies.