validity

Hi, Is there a way to retrieve the SSL Certificate Validity details from a website and dynamically saving to specific cell. For example: B2.Value = google.com the on retrieve the details C2.Value (Not Before Mon, 13 Sep 2021 04:07:13 GMT / Not After Sat, 20 Nov 2021 04:07:12 GMT) and if...

Hi Team I have multiple worksheet on 1 excel file that has 5 columns ([A]Part number, Description, [C]QTY, [D]Approval number, [E]validity). I usually need to check what is the approval number per each part number and it has to be active as well. At the moment my first worksheet (ALL) is just a...

I was in a situation where I had to do some conditional formatting for cells that had invalid entries relative to validation rules. As far as I know there's no formula that checks validity, so I started a thread on the official Excel threads, and I talked a bit about it on twitter, but have...

Hi there! Might be a rather simple question - but has been causing me a TON of trouble... I have a report that is published every weekday - it usually needs to capture the previous BUSINESS DAY, but on MONDAY, needs to reflect the previous FRIDAY (or, business day...). Seems pretty simple...

Hello, I have created a multiplication test for 2nd grader. The goal is for him to fill out the table on the "Test" sheet and then run my macro. The macro would then compare his answers to the those on the (locked) "Answers" sheet. The macro would then display a MsgBox with the number of...