How to Change Sleep Mode of System

Set wshShell=WScript.CreateObject("WScript.Shell")
Do
WScript.Sleep 60000
wshShell.SendKeys "{NUMLOCK}"
wshShell.SendKeys "{NUMLOCK}"
loop

Read More

How to Unhide Sheet all tab from Excel

On Error Resume Next
'vMasterFilePath=WScript.Arguments(0)
'vLogPath=WScript.Arguments(1)

vMasterFilePath="C:\Users\admin\Desktop\Operation\Data.xlsx"
vLogPath="C:\Users\admin\Desktop\Operation\Log.txt"

'For write the log'
Set objFS = CreateObject("Scripting.FileSystemObject")
Set FSO_Handle = objFS.OpenTextFile(vLogPath,8,True)

Set objExcel = CreateObject("Excel.Application")
objExcel.DisplayAlerts = False
objExcel.Visible = True
Set objWorkbook1 =objExcel.Workbooks.Open(vMasterFilePath)


For Each wks In objWorkbook1.Worksheets
MsgBox("sheet name"& wks.Name)

If objExcel.Worksheets(wks.name).visible=False Then
MsgBox(wks.Name)
objExcel.Worksheets(wks.name).visible=True
count=count+1
End If

If wks.autofilterMode Then
wks.autofilterMode = False
End If
objExcel.Worksheets(wks.name).range("A1:BY100").ClearOutline

Next

objWorkbook1.Save
objWorkbook1.Close True
objExcel.Quit

Read More

What is RPA-Life cycle and team structure

What is RPA-Life cycle and team structure

a.)  Analysis Life cycle in RPA begins with analysis phase. Business team and RPA strategist/Architect work together to identify a business process for RPA development. Most of the development follows an agile methodology that to is customized (some modifications) agile. The core intent of this analysis is to identify processes which are feasable for automation, as awell as can save manual effort and bring RoI.

Once after finalizing the process, planning of work that includes resources and time identification is being formulated with the help of an RPA lead.

A formal approach is being documented and after approval from all stakeholders development is started.

b.)  Bot Development-: RPA developer (Team) starts working on requirement in their environment possibly a separate dev environment. Most of the development is wizard driven, with limited or no coding/scripting effort required.
However there are cases where RPA tools have limitation and coding needs to be done.

c.)  Testing -: There are two approaches on which testing is being carried out-

1- Separate testing team
2- Testing done by RPA dev team only

Some of the organisation believes that Unlike SDLC-software development life cycle in RPA testing is not that extremely critical part in most of the organization, therefore, script correctness is verified by the development team usually, with a peer review and once it is done same is ready for deployment.

While other few have a dedicated testing team which perform a dedicated QA like normal SDLC flow.

We recommend to have a dedicated testing team which perform QA of developed bot.

d.)  Deployment and Maintenance-

After the Dev and testing closure, a bot is ready for deployment and enters maintenance phase.Whenever a change comes in a process script/bot is updated or in a case, any issue is being caught in a bot same is being re-deployed by following the dev-test process again.

                           

Read More