All code can be found here for Excel, Confirmit, Now-TV, Access and VBS.
This will show you how to take a collection and save as a CSV with custom delimiter. Prerequisites New business object with a code language of C# Code options to be used for this to work. There needs to be the following inputs – Collection – Collection Delimiter – Text Target – Text In the […]
This will show you how to change the text label inside a div on the page based on another string on the page. First it’s getting all Div elements and then looking into the innerHTML for the word “open”. If its found change the background to red – this is used to help figure out […]
This bit of code will count how many formulas you have used in a workbook, will display a message box of the count and the workbook name! Enjoy! Sub FormulaCount() Dim ws As Worksheet Dim rCheck As Range Dim lCount As Long On Error Resume Next For Each ws In Worksheets Set rCheck = Nothing […]
Quick code to check a selection of variables for a code of 2 which is a fail. Checks all of the top variables [‘qnr_main_section1_PF’……..etc. If any of these are marked as code 2 and if so set var qnT = f(‘qnr_overall_QA_PF’); as 2 which is overall fail Else set to 1 which is pass var qIDsToCheck = […]
Here is the Bitcoin/Cryptocurrency MoDCore referral page. Below is a selection of sites to gain free coins in order of our favourite ones. JSEcoin – Browswer Mining Jsecoin Mining – Web Masters JSEcoin is great for webmasters who own a website. On this site you can mine coins using your browswer or add in script […]