<p>General-purpose VBA techniques spanning the Office suite.</p>
with the push to leverage visual studio and dotnet with office based solutions, especially excel, where is the best article or information on how…
I'm not talking about calling a VBA COM from C#... the other way around! What I would like to do is call a C#…
I have two tables in my access database that I want to be able to export to excel. I can do it by opening…
Occasionally, I have had to build a SQL string in VBA and execute it with Docmd.RunSql(). I have always built these strings by concatenating…
Examples: 'DD/MM/YYYY "1/1/2009" should give `1` "31/1/2009" should give `5` "1/2/2009" should also give `5` Format("1/2/2009", "ww") returns 6. So, how can I get…
My manager tells me that there is a way to evaluate names that are spelled differently but sound similar in the way they are…
Name: From: file:///D:/Samples/TestUpdatedVersion/bin/Debug/TestUpdatedVersion.vsto The customization cannot be installed because another version is currently installed and cannot…
I am wrapping up an office application (VBA) that makes a call to a C# console application to perform some of the heavy lifting…
Usually I use this piece of code to retrieve the content of a folder in VBA. But this doesn't work in the case of…
About a year ago, a manager in another department brainstormed that I could code up some VBA to auto call me in the event…