Solved
May 12, 2009
Hiding an Excel worksheet with VBA
I have an Excel spreadsheet with three sheets. One of the sheets contains formulas for one of the other sheets. Is there is a…
thumb_up 33
trending_up 19
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
May 1, 2009
How can I create a locked-down python environment?
I'm responsible for developing a large Python/Windows/Excel application used by a financial institution which has offices all round the world. Recently the regulations in…
thumb_up 9
trending_up 4
Solved
April 30, 2009
Excel automation – Select all active cells
I have an app where I put a lot of data into an Excel Worksheet. Once I'm done, I would like to select all…
thumb_up 12
trending_up 2
Solved
April 7, 2009
How to change pivot table data source in Excel?
I want to change it from one database to another. There don't appear to be any options to do this on the pivot table…
thumb_up 21
trending_up 24
Solved
March 26, 2009
How to “flatten” or “collapse” a 2D Excel table into 1D?
I have a two dimensional table with countries and years in Excel. eg. 1961 1962 1963 1964 USA a x g y France u…
thumb_up 27
trending_up 24
Solved
March 12, 2009
How to zero fill a number inside of an Excel cell
How do you zero fill a number to 10 positions inside an excel spreadsheet? i.e. If cell A1 has 1234 how can cell A2…
thumb_up 25
trending_up 10
Solved
March 11, 2009
Converting Excel to PDF with VS2008 and Office2007
I am trying to use Interop.Excell to save an Excel Workbook as a PDF file. I am using VS2008 and Office2007, and have downloaded…
thumb_up 7
trending_up 4
Solved
February 11, 2009
How does Excel VSTO Work?
How does Excel VSTO Work? If I create an Excel Workbook solution in Visual Studio 2005 I can then happily code away with full…
thumb_up 7
trending_up 8
Solved
February 6, 2009
Return background color of selected cell
I have a spreadsheet which cells in are colored meaningfully. Does any body know how i can return the background color value of a…
thumb_up 12
trending_up 11
Solved
January 30, 2009
Gridlines in excel through interop
Any idea where the setting is hiding for turning gridlines off while using excel 2003 from interop?
thumb_up 8
trending_up 5