Category "excel-2016"

Setting Metadata in Word and Retrieving in Excel

I'm trying to write a program that updates a Word document's metadata with content control boxes. The Excel document then loops through a directory that holds t

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

How to use COUNTIF to count colors of cells under conditional formatting?

I am trying to figure out how to structure a countif formula. I have a table of data along with (broadly speaking) two sets of conditional formatting: - for the

Check if a cell from a selected range is visible

I have a VBA function in Excel returns a concatenated string of text from cells selected by users. This works as I require, however if there are hidden cells i