1
vote
1answer
161 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
1
vote
2answers
3k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...