Excel VBA

<p>Data processing, dynamic reporting, and workbook automation.</p>

Solved June 21, 2011

Freeze Panes in OpenXml SDK 2.0 for Excel document

I'm generating an Excel workbook using OpenXml and have been following the examples at http://msdn.microsoft.com/en-us/library/cc850837.aspx It would be really useful if I could…

thumb_up 8 trending_up 5
Solved June 9, 2011

XLL Excel addin in unmanaged C++

I have a few mathematical simulations in unmanaged C++ and now I need to integrate them with Excel (so that it is possible to…

thumb_up 12 trending_up 9
Solved June 8, 2011

Opening the Excel application from Python

I am using 'xlwt' to write into Excel files as part of my project in Python. I also need to actually open the Excel…

thumb_up 7 trending_up 3
Solved May 27, 2011

How to clear Sort in Excel 2007

I put filters in some columns with numeric values and then used the "Sort Smallest to Largest" feature in one column. Excel sorts and…

thumb_up 16 trending_up 8
Solved May 2, 2011

Excel – Where condition?

I have two columns with data: A B 1 HELIOS AU 2 HELIOS 3 HELIOS AU 4 SPARTA 5 HELIOS AU Countif(A..;"HELIOS") AND Countif(B..;"AU")…

thumb_up 15 trending_up 7
Solved April 11, 2011

Killing EXCEL.exe Process from C# in a Windows Service

I have a windows service that opens up an Excel spreadsheet via the Microsoft.Office.Interop.Excel.Application object. Application xlApp = new Application(); Workbook workbook =…

thumb_up 10 trending_up 9
Solved April 6, 2011

AutoComplete ComboBox C#

i'm loading huge database from excel (about 2000 items) to combobox. For example CD titles. Then i select 1 CD title from this 2000.…

thumb_up 20 trending_up 4