Solved
April 1, 2011
PostgreSQL Query to Excel Sheet
I need to export some data from PostgreSQL to Excel (quick customer wish), and the last time Excel had serious problems opening or importing…
thumb_up 14
trending_up 16
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
March 24, 2011
Shortcut to Apply a Formula to an Entire Column in Excel
If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the…
thumb_up 335
trending_up 129
Solved
March 18, 2011
Compiler Error: User-defined types not defined
I get the compile-time error "User-defined types not defined" on this line: Dim cn As ADODB.Connection` What could be wrong? Code: Sub test() Dim…
thumb_up 19
trending_up 11
Solved
March 16, 2011
HRESULT: 0x800A03EC – It works on my machine issue when creating Excel files
I am creating an excel report using data coming from mssql server in my asp.net application. Here is my method: [WebMethod] public static string…
thumb_up 9
trending_up 3
Solved
March 14, 2011
How to check from .net code whether “Trust access to the VBA project object model” is enabled or not for an Excel application?
How to check from .net code whether "Trust access to the VBA project object model" is enabled or not for an Excel application? Manually…
thumb_up 16
trending_up 9
Solved
March 5, 2011
openxml spreadsheat save-as
I have an Excel 2007 spreadsheet that I edit with the OpenXML SDK 2. I remove some rows etc. I would like to know…
thumb_up 10
trending_up 12
Solved
February 14, 2011
PHP create Excel spreadsheet and then email it as an attachment
I'm using the following code: <?php $data = $_REQUEST['datatodisplay']; header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment…
thumb_up 9
trending_up 3
Solved
February 8, 2011
Cannot perform runtime binding on a null reference exception
I'm trying to find the dimensions of an Excel table using C# by finding the first null cell within the first column (which consists…
thumb_up 9
trending_up 6
Solved
January 12, 2011
How do I get the old value of a changed cell in Excel VBA?
I'm detecting changes in the values of certain cells in an Excel spreadsheet like this... Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As…
thumb_up 27
trending_up 20
Solved
January 7, 2011
Excel VBA: Alternate Row Colors in Range
I spent a VERY long time today looking up a method to alternate row colors within a specified range. There really isn't a lot…
thumb_up 7
trending_up 6