VBA Core

<p>General-purpose VBA techniques spanning the Office suite.</p>

Solved March 20, 2012

Set a type in VBA to nothing?

I have defined a variable with an own type, say Dim point As DataPoint Public Type DataPoint list as Collection name as String number…

thumb_up 22 trending_up 17

Solved March 9, 2012

I have the name of a worksheet stored as a string in a variable. How do I perform some operation on this worksheet? I…

thumb_up 8 trending_up 4

Solved March 6, 2012

I have some VB6 code that needs to be migrated to VB.NET, and I wanted to inquire about this line of code, and see…

thumb_up 10 trending_up 6

Solved February 12, 2012

PowerPoint entrance animation set up with "Start: With Previous" starts right when a new slide is advanced. However, if you set up an exit…

thumb_up 3 trending_up 12

Solved February 6, 2012

I am building an application in Excel which will enable a user to select from a list of existing excel based tools that have…

thumb_up 13 trending_up 3

Solved January 24, 2012

I'm writing a .Net application that utilises Excel. Any version of Excel from '97 or later is acceptable, but I don't know which version…

thumb_up 6 trending_up 5

Solved January 10, 2012

Aim I am looking to scrape 20/20 cricket scorecard data from the Cricinfo website, ideally into CSV form for data analysis in Excel As…

thumb_up 47 trending_up 32

Solved December 30, 2011

I have a for loop over an array. What I want to do is test for a certain condition in the loop and skip…

thumb_up 116 trending_up 57

Solved December 18, 2011

I am trying to create a piece of code that replaces one word with another. Example: Replace Avenue with Ave and North with N.…

thumb_up 44 trending_up 25

Solved November 10, 2011

Is there a compatibility issue between macros written for XLS, XLSX and XLSM? Will the same macro work for all workbooks?

thumb_up 7 trending_up 4