Programming

RTD server in C#
We need to create an Excel 2003 (version 11) RTD Server in C#. We have searched for a sample Visual Studio 2005 C# project that will correctly create and register a C# RTD Server but have not found a complete solution. We have seen references to the Add-In Express product mentioned on the MSDN web site, but w... 16 Oct 2006 12:51

Automation Error
I have a workbook with macros that was developed using Excel 2000. It has been working fine. Recently, I have Excel 2003 installed in addition to Excel 2000. So there are two versions of Excel on my computer. Now when I open this workbook. I received an error message: Runtime error -2147417848 (80010108) Au... 16 Oct 2006 13:55

Pivot Tables
Hi I use aspnet1.1 and I just discover the Office WebComponents but I can not foind any manual or guide about it I can not find an example about how to publish a pivotTable in Internet Explorer Anyone in here know something about it??? I really need help on this matter beacuse I must pubish a pivot table ... 9 Oct 2006 19:48

SecSvr32 Operation exception
I enounter the same issue.. Did anyone helped you? ChristopheB -- ChristopheB ------------------------------------------------------------------------ ChristopheB's Profile: http://www.officehelp.in/member.php?userid=4637 View this thread: http://www.officehelp.in/showthread.php?t=555617 Posted from - http://ww... 9 Oct 2006 11:23

How to put excel into batch mode
This is an addition to my other questions. In order for me to automate my processes, it's important for excel not to do anything that might put it into a wait state. So far I've dealt with the following: AutomationSecurity on high (3) to disable macros DisplayAlerts to false Prevents modal dialogs (does excel h... 9 Oct 2006 18:14

Select a range within a range
Hi all, I think I'm making this harder than it really is, but I can't see any other way to do it. I have a range, where I want to select a number of rows within it. This range is very large, and I just need to select an "x" number of rows. here is the code i have. Dim x As Integer x = ((intPac... 6 Oct 2006 19:14

Subscript out of range error?
I keep getting a subscript out of range error with this macro. Any help would be great. Public Sub AddSheetToEnd() 'Create a new sheet Dim NewWorksheet As Worksheet Set NewWorksheet = _ Application.Sheets.Add( _ After:=Worksheets(GetLastSheet), _ Type:=XlSheetType.xlWorksheet) ' ... 28 Jul 2006 17:50

David
actually, the app i wrote did exactly that...but i wrote it in the late 90's with a down-levelled version of Excel. "they" made a few changes...and documentation wasn't one of them. if/when i get this working, i'll post something here. thanks! "danAutodesk" wrote: Hi - I finally gave up; wasn't a... 20 Jul 2006 02:13

PageSetup.set_PrintQuality .NET method
Can anyone tell me how this property is set. In the macro it is PageSetup.PrintQuality=600 or PageSetup.PrintQuality=300 But in .NET a c# object seems to only have PageSetup.set_PrintQuality(index,object_p2) according to some sources index value can be 0,1 or 2 0 beging Horizontal print quality,1 being ve... 12 Jun 2006 16:51

MMult and MInv
Hi there, Im trying to work out how to use MMult function in the VBA (i dont want input or output in excel worksheet). But it keeps giving me a runtime error 1004: "Unable to get the MMult property of the WorksheetFunction class" on the MMult line. The funny thing is when i tried changing the array2 into the e... 30 Apr 2006 06:48