create an array from a table in MS Access
Posted on 2011-09-18
I need your help. I am trying to create an array by using a table called "Holidays" and then I will use this array with an excel function below.
Workday = xlApp.Workday(startDate, numberOfDays, HolidaysA)
Table Name: Holidays
The probelm is I dont know how to do as I have a little knowledge in VBA. I have found some code on the internet and I tried to use it, but it is not working:
Dim rs As ADODB.Recordset
Dim Holidays As Variant
Set rs = CurrentProject.Connection.Execute("select * from Holidays")
HolidaysA = rs.GetRows()
Thank you very much in adavce for your help.