Tag: VB
-
Here’s a neat piece of code I use whenever I needed to apply a macro that formats headers on an Excel workbook. I always come across this step whenever I write a datatable to an Excel file. Datatables are being copied as plain text so you have to format it to make it look more… Continue reading
-
If you encounter this error on UIPath saying “Programmatic access to Visual Basic Project is not trusted”, it could mean that your MS Excel’s Macro Trust Settings is disabled. By default, Excel blocks any programmatic access to the application unless the user permits it. You may be invoking an external VBA macro file in your… Continue reading
-
Here are my most commonly used VB expressions for handling date, string, and array/collection values. Will add more to these as I go along. UIPath activities essentially use VB.NET expressions so their API browser is extremely helpful in learning functions and syntax. .NET API Browser:https://docs.microsoft.com/en-us/dotnet/api/?view=netframework-4.7.2 String How to print new line on Message Box Use… Continue reading
