Programming
in [Excel]
|
QueryTable connection using ADO Recordset I have the following code snippet to transfer the results of a SQL Server 2000 sp to an Excel Sheet: Dim Newcn as new adodb.connection Dim oQueryTable As Excel.QueryTable Newcn.CommandTimeout = 0 Newcn.ConnectionString = ConnString ' Connection string passed into this procedure Newcn.Open Newcn.Errors.C... 26 Nov 2006 21:22
Error on Excel 2003 Workbook_Open XmlMaps I am trying to get an XLT to use an XmlMaps ActiveWorkbook."Root_Map").Databinding.LoadSettings(...xml) in a Workbook_Open routine to use an xml file so that I can do a Refresh to load the current data in the xml file but it errors indicating Method '_Default' of object 'XmlMaps' failed. The XLT is mapped and I... 24 Nov 2006 11:57
Making a ConsolidationReference default to the current workbook. I'm dynamically generating an XML spreadsheet in ASP.NET and setting the content disposition to attachment so the user will be able to open or save the document. If they select Open, "[1]" is getting appended to the filename, which is breaking the ConsolidationReference FileName setting in my pivot table. Is ther... 20 Nov 2006 16:05
System.Runtime.InteropServices.COMException (0x80020005) in excel 2k7, but worked well in 2k3 '----------------------------------------------------------------------- option strict off imports System imports System.Reflection ' For Missing.Value and BindingFlags imports System.Runtime.InteropServices ' For COMException Imports Microsoft.Office.Interop.Excel class AutoExcel public shared sub Main() ... 15 Nov 2006 02:25
Use XIRR FUNCTION IN A VB 2005 PROGRAM I'm getting RPC error when I try to register analys32.xll in the VB program. ErrorCode=-2147417851 Message="El servidor lanzó una excepción. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))" Source="Microsoft.Office.Interop.Excel" StackTrace: at Microsoft.Office.Interop.Excel.ApplicationCla... 14 Nov 2006 15:23
Using SessionVariable(LOGON_USER) in VBA Excel macro I am trying to use sessionvariable("Logon_User") in the ASPTypeLibrary.Request object in an Excel macro. I am getting the run-time error 91 object variable or with variable not set each time I try to get the logon_user. The code I am using is: I tried to set the oRequest to new asptypelibrary.request but, an... 19 Nov 2006 22:38
solver: an unexpected internal error occurred, or available memory was exhausted SolverOk MaxMinVal:=1, ValueOf:="0", ByChange:="$H$4,$F$15,$F$27" SolverAdd CellRef:="$H$8", Relation:=2, FormulaText:="$I$8" SolverAdd CellRef:="$L$15", Relation:=2, FormulaText:="$I$4" SolverAdd CellRef:="$L$17", Relation:=2, FormulaText:="$I$4" SolverSolve UserFinish:=True SolverFinish K... 13 Nov 2006 04:54
Chart problem - works in VBA, but not VB.Net The following code was ported directly from some older VBA code that we have. The VBA code works fine, but when we run it from VB.Net we get an exception. What might be the problem? The VB.Net code is simply trying to add a data series to a chart (using Excel 2003). This is the code: ---- Dim worksheet a... 9 Nov 2006 15:51
System error &H8000FFFF (-2147418113) Hallo. What is message: "System error &H8000FFFF (-2147418113)" Thank you ... 9 Nov 2006 08:28
XML ERROR in PivotTable on generated XML spreadsheet I'm developing an ASP.NET application that converts a DataSet populated from a stored procedure into an Excel XML spreadsheet. I've tweaked as many problems as I can with the generated spreadsheet, but I'm still getting this one when I open it in Excel: XML ERROR in PivotTable REASON: Missing Tag FILE: C:\proj... 3 Nov 2006 16:21 |