excel-vba

136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

Solved July 9, 2012

VBA Reference counting – Object destruction

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 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 May 25, 2012

Would like to do this within the confines of VBA (other users have no other development tools to modify). Am aware of 3rd party…

thumb_up 10 trending_up 8

Solved May 11, 2012

I have a VBA macro that copies rows from one worksheet into another based upon finding values in cells in 3 columns. The macro…

thumb_up 21 trending_up 12

Solved May 9, 2012

SCENARIO A word document is embedded in Excel 2011 file. I need to save it as a pdf. Had it been Excel 2010 then…

thumb_up 5 trending_up 7

Solved April 29, 2012

I currently have 2 worksheets in my excel file. The first sheet is known as the Summary page, which displays an summary result of…

thumb_up 9 trending_up 8

Solved April 22, 2012

I'm using Excel 2010, and have defined the following 3 functions in spreadsheet's Module. Option Explicit Public Function AAA() As Double AAA = 3…

thumb_up 6 trending_up 5

Solved April 18, 2012

I'm having problems sending outlook emails using Excel VBA. I have the code to do it - Sendupdate - and it works fine when…

thumb_up 16 trending_up 8