Category "office-2016"

Excel code crashes after a couple of uses, opening a connection to Access

We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det

Using OLEDB for uploading file with Excel 2016

my application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 with the below code. However we update