Solved
January 30, 2012
Why does Excel translate `=10**-2` to `=0.1`?
Try pasting =10**-2 into a cell in MS Excel. After pressing Enter, it turns it to =0.1. I can't seem to find any documentation…
thumb_up 6
trending_up 5
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
January 26, 2012
Array in excel vba
I want to have an array list in vba, hence I have a variant declared in excel vba like: Dim Students(10) as variant Now…
thumb_up 8
trending_up 6
Solved
January 26, 2012
‘Duplicate headers received from server’ Error in Chrome 16 with EPPlus 2.9
I'm playing around with EPPlus 2.9 and for some reason I'm getting Duplicate headers received from server errors when I try to download single…
thumb_up 9
trending_up 5
Solved
January 18, 2012
How to open Excel file with Read Only protection?
I have opened Excel file in my C# WinForm Application adding reference to Microsoft.Office.Interop.Excel.dll and using DSO FRAMER CONTROL. But i want to open…
thumb_up 10
trending_up 1
Solved
January 11, 2012
Create a password protected excel file using apache poi?
I am developing a simple Java program to create excel file using (Apache POI) API. I am using oracle 10g as a database and…
thumb_up 12
trending_up 12
Solved
January 5, 2012
SQL Server stored procedure export to Excel workbook with multiple sheets
How can I export to an Excel workbook from a stored procedure to multiple sheets with few sql statements? I am currently using the…
thumb_up 6
trending_up 5
Solved
December 30, 2011
Excel VBA Run-Time Error 1004
I am using VBA for Excel 2010 and randomly receiving the following error: Run-time error '1004': "The sort reference is not valid. Make sure…
thumb_up 4
trending_up 6
Solved
December 22, 2011
How to create a function that converts a Number to a Bijective Hexavigesimal?
Maybe i am just not that good enough in math, but I am having a problem in converting a number into pure alphabetical Bijective…
thumb_up 10
trending_up 5
Solved
December 21, 2011
Replacing multiple invalid characters in a sheet name
I am writing a fairly large macro which ends by saving the workbook with a name that the user inputted earlier on. I am…
thumb_up 7
trending_up 3
Solved
December 12, 2011
Send an email from Excel 2007 VBA using an Outlook Template & Set Variables
I have a list of data, let's say client information (Name, Email, Amount Owing etc.), stored in an Excel worksheet . My aim is…
thumb_up 8
trending_up 3