Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General questions about VB6/2005 and Excel 2007 compatibility
Hello,
I'm not sure where or how to ask these questions, so bear with me because I am new to these forums. I'm a programmer and relatively new to .NET. My company will soon be upgrading from Office 2003 to 2007 (in about 6 months, give or take). To complicate matters, we are also transitioning many of our VB6 applications to VB 2005. Our VB6 and VB.NET programs interoperate fine with Office 2003. The programs export data to Excel (both .xls and .csv formats). With respect to Access, they simply read from and write to tables. Again, there seems to be no compatibility issues with Excel/Access 2003, with either VB6 or VB 2005. So, the big question is this: Will the VB6 / VB2005 programs operate as expected (that is, with Excel and Access 2003) with the same Office 2007 apps? I realize this is an extremely general question, so I guess what I need to know is where I can get information on compatibility issues. What web sites, articles, etc., would be helpful? I'm trying to compile a list of known issues so that we can develop a plan to try to deal with Office 2007 contingencies. Thanks in advance, Russ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
General questions about VB6/2005 and Excel 2007 compatibility
If you rely on the code as business critical code, get a consultant in. I am
serious, if it is important, you should take the migration seriously and buy in expertise. -- __________________________________ HTH Bob "RMR_Man" wrote in message ... Hello, I'm not sure where or how to ask these questions, so bear with me because I am new to these forums. I'm a programmer and relatively new to .NET. My company will soon be upgrading from Office 2003 to 2007 (in about 6 months, give or take). To complicate matters, we are also transitioning many of our VB6 applications to VB 2005. Our VB6 and VB.NET programs interoperate fine with Office 2003. The programs export data to Excel (both .xls and .csv formats). With respect to Access, they simply read from and write to tables. Again, there seems to be no compatibility issues with Excel/Access 2003, with either VB6 or VB 2005. So, the big question is this: Will the VB6 / VB2005 programs operate as expected (that is, with Excel and Access 2003) with the same Office 2007 apps? I realize this is an extremely general question, so I guess what I need to know is where I can get information on compatibility issues. What web sites, articles, etc., would be helpful? I'm trying to compile a list of known issues so that we can develop a plan to try to deal with Office 2007 contingencies. Thanks in advance, Russ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
General questions about VB6/2005 and Excel 2007 compatibility
Testing..testing..testing.
Just to add another viewpoint, to my knowledge there is no big book that can be dropped from above that lists every little change (and if there was, it would be gigantic). For the most part, most of what you have *should* work (Microsoft is unbelievably great at backward compatibility) but the way to really know is to test everything in a new "test" environment. To add to Bob's suggestion, you might want to devote a test manager to run test scenarios so that you can run all of the code in the new environment. You'll also want to know if any data is modified or calculated differently in the new environment, so that should be part of the test. Recently I tested a very complicated Excel solution that was created in Excel 2003, in 2007. The only thing Excel complained about was that I could not use one range name...since it was reserved by Excel 2007. Literally, and I mean literally, everything else worked in 2007 with no modification. Pretty nice. -- Tim Zych www.higherdata.com Compare data in worksheets and find differences with Workbook Compare A free, powerful, flexible Excel utility "RMR_Man" wrote in message ... Hello, I'm not sure where or how to ask these questions, so bear with me because I am new to these forums. I'm a programmer and relatively new to .NET. My company will soon be upgrading from Office 2003 to 2007 (in about 6 months, give or take). To complicate matters, we are also transitioning many of our VB6 applications to VB 2005. Our VB6 and VB.NET programs interoperate fine with Office 2003. The programs export data to Excel (both .xls and .csv formats). With respect to Access, they simply read from and write to tables. Again, there seems to be no compatibility issues with Excel/Access 2003, with either VB6 or VB 2005. So, the big question is this: Will the VB6 / VB2005 programs operate as expected (that is, with Excel and Access 2003) with the same Office 2007 apps? I realize this is an extremely general question, so I guess what I need to know is where I can get information on compatibility issues. What web sites, articles, etc., would be helpful? I'm trying to compile a list of known issues so that we can develop a plan to try to deal with Office 2007 contingencies. Thanks in advance, Russ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#VALUE! from Function()...Posted in Excel General Questions by mis | Excel Programming | |||
Testing Reverse Compatibility and Compatibility in General | Excel Discussion (Misc queries) | |||
excel general questions | Excel Discussion (Misc queries) | |||
SPAM in Excel General Questions | Excel Discussion (Misc queries) | |||
Compatibility with Excel 97 Questions | Excel Programming |