Archive for category Excel
My original post on my SQLConcat function has received some traffic, but the code had a pretty serious error in it. This was due to my previous lack of understanding about VBA’s IsMissing() function. I’ve also added some extra functionality to the code to allow for adding parenthesis along with quotes. The added functionality makes it easier to adhoc insert statements like this.
Insert into [tbl] ([col1],[col2]) Values (1,'hello'),(2,'world')
I’ve got a quickie, but a goodie for you today. I’m going to show you how you can avoid the Run-time Error ‘1004’ : You typed in an invalid name for a sheet or chart error message by using an extremely simple custom function. Read the rest of this entry »