Solved
July 27, 2016
ADO Recordset data not showing on form
I've got a frustrating issue on MS Access 2010 that I would at this stage qualify as a bug. And after having tried all…
thumb_up 7
trending_up 10
vba
81 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
July 18, 2016
Access files with long paths (over 260)
I'm using Microsoft Scripting Runtime (FSO) to parse folders and produce a list of all of its contents, the folders are on a network…
thumb_up 6
trending_up 7
Solved
May 2, 2016
C# Char from Int used as String – the real equivalent of VB Chr()
I was converting a VBA macro to C#. And in VBA chr(7) can simply be concatenated to a string as if chr() would yield…
thumb_up 21
trending_up 9
Solved
January 17, 2015
Can I compile VBA on workbook open?
I am trying to find a way of compiling the code in VBA on workbook open. I can do this manually by opening the…
thumb_up 7
trending_up 7
Solved
July 17, 2014
VBA If = ?
I'm fairly new to VBA, and I can't find an easy way to test if any of the specified variables equal a specified value.…
thumb_up 11
trending_up 7
Solved
February 26, 2014
VBA WinHTTP to download file from password proteced https website
I'm trying to save a file from https password protected site using WinHTTP. Here's the code: Sub SaveFileFromURL() Dim FileNum As Long Dim FileData()…
thumb_up 8
trending_up 3
Solved
December 27, 2013
VBA: Test if string begins with a string?
In VBA, what's the most straight forward way to test if a string begins with a substring? Java has startsWith. Is there a VBA…
thumb_up 53
trending_up 28
Solved
December 19, 2013
Object variable or With block variable not set (Error 91)
I have the following code: Sub AddSources() Dim pubPage As Page Dim pubShape As Shape Dim hprlink As Hyperlink Dim origAddress() As String Dim…
thumb_up 6
trending_up 5
Solved
October 30, 2013
Pattern to handle expected errors locally, rethrow unexpected errors
Sometimes a certain bit of code will raise an error in an expected way, and it's most convenient to handle it locally rather than…
thumb_up 4
trending_up 10
Solved
October 16, 2013
Run VBA script from R
I have to manage a workflow involving R-scripts and VBA-code. I would like to run the process in R (where most of my code…
thumb_up 6
trending_up 7