469,628 Members | 1,016 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

Excel Automation with Excel 97 thru 2003

I have VB.Net code that opens Excel files and imports data from them. It
works fine for all versions up to 2003 and has for over a year. We have
users updating to Office 2003 and the Excel automation breaks on those
machines. Does coding to the earliest supported version of Excel not apply
once you get to 2003?

Nov 28 '05 #1
1 1562
Jan
Check: http://www.gemboxsoftware.com/ExcelLite.htm#Automation

Few possible solutions:

a) Recompile your app with a reference to Excel 2003 type libraries (and
upgrade all your users to Excel 2003), or

b) Stop using automation at all (use OleDb or some third-party control).

Jan
GemBox Software
--
ExcelLite Free for .NET - Easily read and write Excel files (XLS or CSV)
from your .NET apps. See http://www.gemboxsoftware.com/ExcelLite.htm
--
"Troy" <Tr**@discussions.microsoft.com> wrote in message
news:CD**********************************@microsof t.com...
I have VB.Net code that opens Excel files and imports data from them. It
works fine for all versions up to 2003 and has for over a year. We have
users updating to Office 2003 and the Excel automation breaks on those
machines. Does coding to the earliest supported version of Excel not
apply
once you get to 2003?

Nov 29 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Mansi | last post: by
3 posts views Thread by Carlos Magalhaes | last post: by
reply views Thread by Dickson | last post: by
6 posts views Thread by a.theil | last post: by
6 posts views Thread by Mark Rae | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.