Solved
July 20, 2012
MS Access send email (not from outlook or user’s email)
I know this question has been asked a few times in various context, but I have not found a clear answer. I have email…
thumb_up 11
trending_up 7
vba
81 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
June 18, 2012
Difference in type between using and not using Set keyword
I just solved a problem I was having putting the "Set" keyword in a definition line but what I would like to know is…
thumb_up 14
trending_up 5
Solved
May 30, 2012
Copy Elements From One Page To Another in Multipage with VBA in Excel
I have a multipage in a userform. During run-time, the user can choose to add x number of pages at any time. The elements…
thumb_up 6
trending_up 5
Solved
May 13, 2012
Remove whitespace in VBA excel
I have some code for move text from cell to cell Dim startIndex As Integer Dim toIndex As Integer Dim f As String Dim…
thumb_up 11
trending_up 1
Solved
April 24, 2012
excel vba: make part of string bold
I have excel cells which contain entries like this: name/A/date name/B/date name/C/date Cell content is displayed on multiple lines in the same cell. I…
thumb_up 7
trending_up 4
Solved
April 19, 2012
Run Excel Macro from Outside Excel Using VBScript From Command Line
I'm trying to run an Excel macro from outside of the Excel file. I'm currently using a ".vbs" file run from the command line,…
thumb_up 14
trending_up 17
Solved
April 12, 2012
Automatically creating hyperlink to another sheet by text
I would like to know how to create a hyperlink from one excel sheet to another, automatically through a script, based on equal text…
thumb_up 10
trending_up 4
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
Reference excel worksheet by name?
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
Equivalent of “Dim As String * 1” VB6 to VB.NET
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