filmov
tv
Start with VBScript | VBScript in UiPath | VB.net | dotnet code | VBScript | Technical Mayuri

Показать описание
Here is something useful for dotnet developer and integrating dotnet to UiPath
This video will consist to detailed explanation of how to start with VBScript.
We need to follow below steps to get starting with VBScript
1.Save the excel file as macro base file.
2.Open the macro based file, go to developer tab and click visual basic option.
3.You will direct to a new window popup, we will need to insert a module with the option of insert(then) - Modules.
4.Insert a sub procedure to write a code with syntax of "sub Procedure Name()"
5.End the procedure with "End Sub".
6.We can write our code in the procedure define in step 4.
Assign value to any cell
1.Range function is used as to locate the cell value or range value we need to assign the actual value.
2.Range function has parameters of the cell location.
3.We need to add value function after range function to assign the value.
For example :
we need to assign "A" alphabet to "A1" location.
We need to pass "A1" in the range function follow by value function
range("A1").value = "A"
This video will consist to detailed explanation of how to start with VBScript.
We need to follow below steps to get starting with VBScript
1.Save the excel file as macro base file.
2.Open the macro based file, go to developer tab and click visual basic option.
3.You will direct to a new window popup, we will need to insert a module with the option of insert(then) - Modules.
4.Insert a sub procedure to write a code with syntax of "sub Procedure Name()"
5.End the procedure with "End Sub".
6.We can write our code in the procedure define in step 4.
Assign value to any cell
1.Range function is used as to locate the cell value or range value we need to assign the actual value.
2.Range function has parameters of the cell location.
3.We need to add value function after range function to assign the value.
For example :
we need to assign "A" alphabet to "A1" location.
We need to pass "A1" in the range function follow by value function
range("A1").value = "A"