Excel 2003 DDE bug
Thu, 12 Jun 2008 17:17:04 -0700
I have encountered a bug in the way Excel 2003 saves data passed to it
via DDE. The bug exists in Excel 2003 SP3 (build 11.8211.8202). It may
well have been introduced by SP3. The bug also affects Excel 2007 when
it saves spreadsheets in the older binary file format.
When Excel saves spreadsheets containing DD ...
|
Excel data import - version question
Fri, 23 May 2008 18:31:23 +0100
We distribute a MS Access (97) application which references Excel's object
model to import various spreadsheet content. This works well up to and
including Excel 2003. In principle would there be any major problems using
the app. on a 2007 Excel file ? and if so how could this be overcome. The
Access app is ...
|
using UDL with Excel 2003 pivot table
Sat, 26 Apr 2008 18:56:44 +0300
Hi all,
It seems that microsoft is no longer supporting ODBC connection to Visual
Foxpro 9. Instead, it is recommended to use OLE database provider. I have
created
the connection information to be used with the OLE driver (UDL file) but I
can't find how to use it from within the pivot table "get data" wizard. ...
|
Wordart displays inncorrectly when created using VB.Net (2008)
Fri, 11 Apr 2008 05:19:01 -0700
I do a reasonable amount of creating Excel sheets using VB.Net. For the
particular application, I want to add a watermark to the center of every
excel sheet page (except the first) so if they are printed out or sent
electronically, they have the word "Confidential" on the sheets.
I'm using VS2008 and Office ...
|
Excel ODBC Driver May Determine Wrong Data Type (Q141284)
Fri, 4 Apr 2008 07:39:12 -0700 (PDT)
Can anybody tell if this:
http://support.microsoft.com/kb/q141284/
is still a problem? ...
|
Dont read
Tue, 25 Mar 2008 11:58:08 +0100
Vendo coche de segunda mano, Seat ibiza, a? 2001 km
35000, Solo por 4500 euros.
[URL=http://www.anunciosgratis.de]Anuncios Gratis[/URL]
www.AnunciosGratis.de http://www.AnunciosGratis.de Anuncios
Gratis. ...
|
ActiveCell.Dependents kills code
Wed, 12 Mar 2008 23:51:00 -0700
I have been trying to get a .net application to use the .Dependents property
of the activecell. It works perfectly if there are dependents however if the
cell has no dependents then the code stops executing - no errors, no way to
catch etc.
I have tried with VB and C#. I also tried the same thing in VBA a ...
|
|
|
Microsoft.Office.Interop.Excel.ApplicationClass' to interface type
Fri, 7 Mar 2008 07:47:05 -0800
Hi,
I created an application using C# in Visual Studio 2008. The application
gets all the data from the Microsoft Projects Planner (MPP) file and then
after some complex calculations save some figures to Excel file. I am using
Microsoft Interop Assemblies 11 for accessing the Projects and Excel.
The appl ...
|
Passing arrays from Excel (VBA) to C# using COM interop
Tue, 26 Feb 2008 15:53:28 -0800
Hi - I'm using VS2005/Excel 2007 and can pass scalars from Excel to a C#
class exposed with [ClassInterface(ClassInterfaceType.AutoDual)] and setting
the assembly to Register for COM Interop and all works fine until I try to
pass an integer array from VBA to C#: I initially get "Function or interface
marked as r ...
|
Help-Opening password protected excel 2007 file on office2003 mach
Mon, 25 Feb 2008 02:25:01 -0800
I have a requirement where I need to open the password protected Excel2007
file on machiine haveing office2003,though code and it should be invisible to
the user.
Whenever I am trying to open the password protected 2007 ppt or excel,
through code it is prompting to enter the password and application become ...
|
