Code Section
All code can be found here for Excel, Confirmit, Now-TV, Access and VBS.
Protected: Automations
There is no excerpt because this is a protected post.
Blue Prism – Collection to CSV – Custom Delimiter
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 […]
Blue Prism
Area where Blue Prism information and snippets are stored.
Javascript buttons for navigation
Here is an example of how you could use javascript buttons on a page. Inside a info node on the page if you add the name of your function. ^mainpage()^ In a script node if you name the function the same and enter the code – function mainpage() { var outputHTML = “”; outputHTML += […]
Change Reportal Label based on Text in Div
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 […]
Small image in survey, click to enlarge
This code will add a small image to survey page and will enlarge the image if the user clicks on it. HTML in survey question × Style script in the instruction node – JavaScript node – // Get the modal var modal = document.getElementById(‘myModal’); // Get the image and insert it inside the modal – […]
Protected: Virtual Assistant
There is no excerpt because this is a protected post.
Count formulas in a workbook
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 […]
Confirmit array If statement
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 = […]
The Bitcoin Referral Page
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 […]