Running a sql function in an Excel macro
Posted on 2012-03-12
I have a scalar function I have written in SQL. It takes in 2 date times and spits out our business cycle time.
I'd like to be able to have a macro that will look at two columns of cells and run the function for each row that has data.
IE, I want columns A and B to have a bunch of rows with Date1 and Date2.
I want to run a macro that will put
myDateFunction(A1, B1) into column C1
myDateFunction(A2, B2) into column C2