Excel Automation with Excel 2003

Troy

I have VB.Net code that opens Excel files (Password Protected) 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?

Jan 10 '06 #1

Subscribe Post Reply

1412

Carlos J. Quintero [VB MVP]

I don´t think so, but could you ellaborate a bit about the specific break?
Some (minimal) code?

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio 2005, Visual Studio .NET,
VB6, VB5 and VBA
You can code, design and document much faster in VB.NET, C#, C++ or VJ#
Free resources for add-in developers:
http://www.mztools.com
"Troy" <Tr**@discussions.microsoft.com> escribió en el mensaje
news:DF**********************************@microsof t.com...

I have VB.Net code that opens Excel files (Password Protected) 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?

Jan 11 '06 #2

by: Benjamin | last post by:

I am making a Windows EXE (.NET Visual Basic Windows Application). I would like to make it possible to open Excel Worksheets from my EXE. This should work independent of Excel version on client...

.NET Framework

Excel 2003 Automation (connect to a running instance)

by: cybertof | last post by:

Hello, Is there a way to connect (through automation) a c# application to a running Excel 2003 instance on a specific workbook ? In the past, i used to use GetObject(...) function in VB6. ...

C# / C Sharp

Excel Automation

by: Mansi | last post by:

I need to do some research on how to use excel automation from c#. Does anyone know of any good books related to this subject? Thanks. Mansi

C# / C Sharp

Excel Object Library(s)??

by: eye5600 | last post by:

I want to read/write Excel files but I am having trouble getting started. Using MS article 302084 as a cookbook, I try to add the reference for MS Excel Object Library. Two versions are listed, 5 &...

C# / C Sharp

Excel Com automation - Formulas

by: Carlos Magalhaes | last post by:

Hey All, I am doing some excel automation using the excel COM. I can do most of the functions and its working well until I come across a formula. I can run a formula and insert the formula...

Visual Basic .NET

Excel Automation with .NET

by: Mitchell Vincent | last post by:

Does anyone have some good examples of Excel automation with (VB).NET? I have some Excel spreadsheets that a customer needs parsed out but I've never tried to use Excel programatically before! ...

Visual Basic .NET

Excel automation

by: a.theil | last post by:

Please help! I need a simple excel automation, just 2 write some files into excel. I do: Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng As...

Visual Basic .NET

Excel Automation with Excel 97 thru 2003

by: Troy | last post by:

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...

Visual Basic .NET

Output to Word & Excel

by: Mark Rae | last post by:

Hi, My client has asked me to provide a "quick and dirty" way to export the contents of a DataGrid to both Excel for analysis and Word for editing and printing, so I'm investigating client-side...

ASP.NET

Invalid Sheet Name in Excel 2003

by: =?Utf-8?B?THluZXJz?= | last post by:

Hello All, We have a VB.NET application writen using VS 2003. This application apens an excel file from a vendor, reads the data and performs whatever functions it needs. We recently upgraded our...

Visual Basic .NET

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Excel Automation with Excel 2003

Similar topics