General questions about Visual Basic and Excel/Access

[RMR_Man]

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

 

[Bob Phillips]

See response in .programming