Solved
December 7, 2011
How should I Notify the user during a long process?
I have some long processes that require notifications to the user at successive stages, so that he doesn't get to believe Excel has crashed…
thumb_up 8
trending_up 3
Excel VBA
<p>Data processing, dynamic reporting, and workbook automation.</p>
Solved
November 28, 2011
How do I elegantly import an Excel file into Sql Server via a Coldfusion HTML form?
Does anyone have an elegant suggestion for how to get the contents of an Excel spreadsheet into SQL Server via a web form? I…
thumb_up 11
trending_up 1
Solved
November 25, 2011
How to change Format of a Cell to Text using VBA
I have a "duration" column in an Excel sheet. Its cell format always changes — I want convert the duration from minutes to seconds,…
thumb_up 55
trending_up 29
Solved
November 16, 2011
How to set NumberFormat to Number with 0 decimal places
The below VBA in MS Access is run to format my Excel sheet. However, it is formatting to Number with 2 decimal places. How…
thumb_up 11
trending_up 5
Solved
November 15, 2011
Loading CSV files into MySQL Workbench
I have a lot of excel/ CSV files that I need to load into my db in MySQL Workbench (I'm on Mac OS X).…
thumb_up 12
trending_up 18
Solved
November 15, 2011
Insert image to excel file using JXL without stretching it
I can insert image to my excel file using jxl usingsheet.addImage(WritableImage obj). My problem is that, it stretches based on the args of WritableImage.…
thumb_up 6
trending_up 7
Solved
November 12, 2011
Can’t open excel file generated with excelLibrary
I'm using excelLibrary to programatically create excel files but I get a file format error when I try to open the generated files in…
thumb_up 38
trending_up 11
Solved
November 8, 2011
How to script Excel files with Groovy
I want to create excel files in Groovy, then have them plotted. This code was taken from an example using Microsoft's Shell Scripting language:…
thumb_up 12
trending_up 3
Solved
November 2, 2011
Differentiate trim and trim$ in vba
What is the difference between trim and trim$ in vba? Accidentally today when I used left and trim functions in vba, The compiler said…
thumb_up 16
trending_up 8
Solved
October 24, 2011
How can I make an Excel Sheet forget that it was generated from TFS?
I have an Excel sheet which is generated by opening the result from some query based on TFS work items. I'm using this Excel…
thumb_up 15
trending_up 10