Solved
October 6, 2011
how to split a string with multiple delimeters in vba excel?
I want to split a string with multiple delimeters using Excel VBA. One of the strings is: d1-d2 d3 d4 We have a dash…
thumb_up 20
trending_up 7
vba
81 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
August 31, 2011
Is there a method for getting the Excel VBA IDE working with TFS 2010?
I have team members that need to be able to checkin VBA modules/classes created in Excel 2007/2010. I want to be able to use…
thumb_up 4
trending_up 14
Solved
August 26, 2011
Can I make Excel scroll smoothly without using middle-click?
I must work with nightmare Excel files. (I didn't create them, I just have to work with them). They were so big (more than…
thumb_up 6
trending_up 9
Solved
August 8, 2011
Subtracting from a date in VBA?
I'm having big problems doing operation with the date in Excel VBA. I have a form that has a textbox where the user will…
thumb_up 18
trending_up 9
Solved
May 3, 2011
Code to loop through all records in MS Access
I need a code to loop through all the records in a table so I can extract some data. In addition to this, is…
thumb_up 46
trending_up 19
Solved
April 19, 2011
User Defined Functions NOT recalculating
I recently took a large, stable XLSM file, and split it apart into an XLAM and XLSX. Thousands of cells in the XLSX call…
thumb_up 4
trending_up 8
Solved
April 17, 2011
How do I declare an array variable in VBA?
I need to add the var in array Public Sub Testprog() Dim test As Variant Dim iCounter As Integer If test = Empty Then…
thumb_up 25
trending_up 17
Solved
April 13, 2011
Using VBA to get extended file attributes
Trying to use Excel VBA to capture all the file attributes from files on disk, including extended attributes. Was able to get it to…
thumb_up 15
trending_up 11
Solved
December 29, 2010
How do I get regex support in excel via a function, or custom function?
It appears that regex (as in regular expressions) is not supported in excel, except via VBA. Is this so, and if it is, are…
thumb_up 26
trending_up 17
Solved
November 26, 2010
Does Dir() make any guarantee on the order of files returned?
I am trying to clean up some existing code Sheets("Control").Select MyDir = Cells(2, 1) CopySheet = Cells(6, 2) MyFileName = Dir(MyDir & "wp*.xls") '…
thumb_up 6
trending_up 8