Excel VBA

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

Solved August 15, 2012

Converting Double to DateTime?

I have a .CSV file which I am reading into a C# program. In one of the columns, there is a date, but it…

thumb_up 28 trending_up 5

Solved August 13, 2012

I need to find if a cell is visible on the screen. By visible, I don't mean hidden. I am specifically trying to find…

thumb_up 11 trending_up 8

Solved August 2, 2012

I'm trying to download and then open an Excel spreadsheet attachment in an Outlook email using VBA in Excel. How can I: Download the…

thumb_up 43 trending_up 16

Solved July 17, 2012

I'm having a problem fromatting cells in an excel sheet. For some reason my code seems to be changing the style of all cells…

thumb_up 14 trending_up 16

Solved July 9, 2012

Lately I've bumped into a question that made me pounder; it kept me busy and I couldn't find a transparent explanation for it on…

thumb_up 7 trending_up 19

Solved June 22, 2012

I want to open all files in a specified folder and have the following code Sub OpenFiles() Dim MyFolder As String Dim MyFile As…

thumb_up 14 trending_up 7

Solved June 21, 2012

I have a web project (.NET 4) that needs to access an Excel file, but it ends up with the following error message: Error…

thumb_up 11 trending_up 4

Solved June 14, 2012

we have several tens of macro enabled excel files, each of those contains few VBA modules and in each of those modules there are…

thumb_up 9 trending_up 5

Solved June 11, 2012

I've been trawling through page after page on Google and here looking for a solution to this seemingly simple request, but to no avail.…

thumb_up 5 trending_up 6

Solved June 6, 2012

I am trying to find a function that will return the number of cells within a given range that have a number in them.…

thumb_up 14 trending_up 5