Code Section
All code can be found here for Excel, Confirmit, Now-TV, Access and VBS.
There is no excerpt because this is a protected post.
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 […]
Area where Blue Prism information and snippets are stored.
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 += […]
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 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 – […]
There is no excerpt because this is a protected post.
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 […]