cac

Hello and thank you for any attention my post may receive. I am trying to pass the results from a input box to a ws and message box. It works fine with pasting to the ws, however returns and error for the message box. Any help will be greatly appreciated. Private Sub test() Dim s As...

Experts, I'm in the process of writing a couple of VBA scripts that will enable the user to download an Excel file from our password protected SharePoint site and import the data into the active workbook. I work for a government office, and our SharePoint site required a CAC login (CAC card...

Hi All I have been working on opening/saving files using previous day. I now need to 'save' a workbook with previous month in the filename. The code I have is based on what has worked before: Sheets("Monthly CAC Report").Select ActiveWorkbook.Names.Add Name:="Locator", RefersToR1C1:= _...

Problem: We searched a total number of cases (total cases searched) and found errors in x number of cases (cases found). The average errors in those number of cases found is "average mistakes per case". These cases were searched using 3 different softwares: Non-CAC, CAC, and Legacy Scrubber...

I have two books, Book1(CA) and Book2(CAC). Columns A and B of each book have the same data but not necessarily on the same row. Column A = "Trial Date" Column B = "Hosting Club" in each book. "Hosting Club" name in CA may not be spelled exactly the same or use upper case characters like in...