วีดีโอ

Hi @Suraj, please use the colorIndex property to detect the colour.

To check if everything has been inserted successfully you can cross verify each and every row of data from excel and use select query in SQL server mgmt studio and check if each and every row of data is matching or not from excel

Hi, First make use of the email dictionary key to check if attachment contains extension as jpeg or png or whatever the extension is and then use the action i.e. save email attachment from the email package to download that particular file into your required local folder.

We can use that as well it is up to you how you want to use it.

@@abhishekarora6136 And other thing you used recorder action to click but we already have click in sap package which is more reliable I think. I don't know that so I was just asking?

@@pushpendrakowthavarapu9317 Both are reliable but the only difference in using recorder and SAP package is that when you use recorder to capture an object the object id will be auto populated in the properties but if you use SAP package then first using script recording and playback option in SAP you need to record the script in order to get the object id and then put that in the field path textbox in the properties section of that action.

Please connect with me around 11 AM will let you know how to do it

@@abhishekarora6136 Hi Abhishek, how do I connect with you?

Yes we can connect tomorrow afternoon at 3 PM

Yes it is enterprise edition

To convert to number format select the whole column use keystrokes ctrl+c and then do alt+e+s+v and then press enter and the whole column would change to numeric format

@@abhishekarora6136 thanks

Thanks a lot Aunty ji for your encouraging words

Sure will keep posting

Okay will do after another user video request on Executor part of WLM

Hello

Okay will create and upload the same within some days

Can we connect to see the issue

To get field path you need to record script from aap and get the ID of that control and copy and paste that control id into the field path. If you still have any doubt please connect with me and call me on 9910796342.

Delete is used and when we delete the row we have to select one option out of multiple options so in this case I used to shift it up after deleting the row

Can you try with VBA to check how much time it takes because with Automation 360 it is not possible. If you face any issues then we can connect. You can call me on 9910796342

You can call me tomorrow morning at 10:30 AM on 9910796342 and will setup the meeting to see the issue and resolve it then and there. Will this suit you

Share your email id will send it

From the file package drag and drop the get path action and select the tab accordingly where your file is located and then browse for the file for which you want to get the path

Bookmarks need to be added manually

Sure will make it

Can you call me on 9910796342 will connect and explain you how to do this

You can call me on 9910696342 I also give class session on various topics such as VBA, Automation Anywhere

Sure will make it

Sure will make it

Okay will make video for the same and most probably starting next week you would get the video for the same.

Sure will create the video on the same

Can you please connect with me for this will let you know about it Mobile - 9910796342

Basic idea of mainframe automation is to extract or enter/write information from the mainframe so that the repetitive task performed by business people can be automated into the task bots Terminal emulator is a software program which mimics same environment needed to access mainframe. If you still have any queries then we can connect on Thursday. You can connect with me on below mobile number Mobile - 9910796342

Can we connect on weekend?

@SurajKumar-jn4lb yes sure

The macros can be called only if they are saved in xlsm or xlsb file extension. So access macro cannot be called from Automation Anywhere

If you convert your access macro to VBA code then it is possible to call macro from Automation Anywhere

Thanks for your feedback. If you want any specific video then also please let me know in the comments section

Thank you Abhishek I watched all your videos I like your way of explain. and please do few more videos in vba and dynamic web application like by using dmx path

Sure will share more such videos on the same.

Yes you can connect personally with me on 9910796342

Most welcome

Hi you can take the length for the string and subtract 1 from it and then using sub string take that new length amount of characters and put that text into new variable

This would be treated as number if you have taken the type of variable as value

@@abhishekarora6136 yea it’s taken as value only

@@abhishekarora6136 issue is that in that variable I will capture multiple value and updating in the excel through database by giving comma like (00145,5600,00789) so I need to delete bfr zeros

9910796342