ConvertFileToExcel | UiPath | VBA
23:57
Position Window activity | UiPath
10:33
Join DataTable Activity| UiPath
6:06
linq tutorial Part 2 | UiPath
6:48
3 жыл бұрын
LINQ tutorial Part1 | UiPath
8:59
3 жыл бұрын
Hide Excel sheet using UiPath | Macro
12:47
Array To String using UiPath
7:36
3 жыл бұрын
Пікірлер
@krishnaprasad1102
@krishnaprasad1102 27 күн бұрын
Hi how to remove duplicate numbers in a string.. ex input="312213" 1) how to remove duplicate 2) How to make it in descending order
@outthemud6210
@outthemud6210 4 ай бұрын
Please remove the music
@nagendranani7848
@nagendranani7848 4 ай бұрын
Hi, this is great, but if I have excel with 5 sheet but want only one sheet as pdf. then how can we do that?
@gangadayal4585
@gangadayal4585 5 ай бұрын
Very Very Thanks
@ravishmahajan9314
@ravishmahajan9314 7 ай бұрын
Hi Great video, kindly help me on how do i get stsrted with ui path? How much time i will require to learn it? Is there any programming knowledge required?
@letsautomate2701
@letsautomate2701 7 ай бұрын
Thank you:). You can start by taking course at UIPath academy. It just takes basic level of programming knowledge
@dagowalles6790
@dagowalles6790 8 ай бұрын
How i can get only the rows with "dd/MM/yyyy" format and discard the other data? Please helpme 😢
@letsautomate2701
@letsautomate2701 7 ай бұрын
Sure i can help you with. Can you share the code snippet with me?. I can help you fixing it
@sidhumehta85
@sidhumehta85 8 ай бұрын
thanks you it helped me alot
@letsautomate2701
@letsautomate2701 7 ай бұрын
happy to know it helped!
@kavithaNM2023
@kavithaNM2023 11 ай бұрын
volume is too low
@letsautomate2701
@letsautomate2701 10 ай бұрын
Will work on those. Thanks for feedback
@subhasishghosh2467
@subhasishghosh2467 Жыл бұрын
Can I add row with this array
@letsautomate2701
@letsautomate2701 10 ай бұрын
Yes u can
@sudeeptapillai4421
@sudeeptapillai4421 Жыл бұрын
Can you please provide video on trouble shooting
@letsautomate2701
@letsautomate2701 10 ай бұрын
Sure will make one
@JJ-yt8ww
@JJ-yt8ww Жыл бұрын
'promo sm' 💘
@AniruddhAMMishra
@AniruddhAMMishra Жыл бұрын
finally got the solution kzbin.info/www/bejne/iabHpKFtr6yqjbMsi=Yn-Zw0qqFe1zFPQk
@riyabanerjee7286
@riyabanerjee7286 Жыл бұрын
Hi ! I am getting windows script error using the same code can you please help me It says No Signature was present in the subject
@AniruddhAMMishra
@AniruddhAMMishra Жыл бұрын
If file path change every time how can I pass file path as argument in .vbs ? I have tried to using Start Process activity and put path of .msg file inside quotation in Arguments Arguments:"//B //Nologo path\to\cscript.vbs ""C:\Users\msg file ame.msg""" Below Code: Dim OlApp Dim Eml Dim Arg Set Arg = WScript.Arguments Dim File File = Arg(0) Set OlApp = CreateObject("Outlook.Application") Set Eml = OlApp.CreateItemFromTemplate(File) Download(Eml) Sub Download(objEml) For Each Attch In objEml.Attachments Attch.SaveAsFile "C:\Users\Desktop\Emails\msg file\" & Attch.FileName Next End Sub after run there is no extraction from .msg file Please help
@arifsayyed9967
@arifsayyed9967 Жыл бұрын
Didi, how to filter data by latest date in uipath for excel file having date in text format as mm/dd/yyy
@letsautomate2701
@letsautomate2701 Жыл бұрын
Hello!, you can use the same logic explained in the video, however instead of passing the date as text format, convert them into system.date format
@arifsayyed9967
@arifsayyed9967 Жыл бұрын
​@@letsautomate2701thank you 😊
@Praveensonga
@Praveensonga Жыл бұрын
can u share the script file and also can we do this for likee 500 msg files.if yes please share ur inputs
@letsautomate2701
@letsautomate2701 Жыл бұрын
Hello, firstly sorry for the delayed response! Unfortunately the script is in a laptop which not working, could you please go over the video and write the script? Also yes you can use the script for 500msg files or more
@164906
@164906 Жыл бұрын
<DataTable>.AsEnumerable().Select(Function(a)a.Field(of string)(<Column_Name>).ToString).ToArray() worked for me .. Thank you !
@letsautomate2701
@letsautomate2701 Жыл бұрын
Glad it worked ☺️ no problem at all!
@muhammadabdullahfaqih1097
@muhammadabdullahfaqih1097 10 ай бұрын
this one worked for me, but toarray in your video not @letsatomate2701
@LaxmiShetty-mm3lc
@LaxmiShetty-mm3lc Жыл бұрын
This works. Thanks for explaining 😃
@letsautomate2701
@letsautomate2701 Жыл бұрын
No problem! Glad that it helped you 😊
@SiddharthMishra-t1l
@SiddharthMishra-t1l Жыл бұрын
Hi. I have few queries related to ui path. Where can we connect to discuss ?
@letsautomate2701
@letsautomate2701 Жыл бұрын
Hello Siddharth, do post your questions in here, i will try my best to answer them
@SiddharthMishra-t1l
@SiddharthMishra-t1l Жыл бұрын
@@letsautomate2701 This is business account. Can not put details here !!
@letsautomate2701
@letsautomate2701 Жыл бұрын
@@SiddharthMishra-t1l got it!, my youtube channel has LinkedIn profile linked to it. We can discuss your question there
@GitaShree-j1k
@GitaShree-j1k Жыл бұрын
Wonderful!! I was looking for it for past 2days. You are a life saver 😊
@letsautomate2701
@letsautomate2701 Жыл бұрын
Glad i could be a help 😊
@AnkitaNarayanRai
@AnkitaNarayanRai 2 жыл бұрын
how to hide a column in excel using macro
@letsautomate2701
@letsautomate2701 Жыл бұрын
Firstly sorry for late response. But i will make sure to answer all your questions sooner. To hide column using macro : first select the column then use following code : selection.EntireColumn.Hidden=True Hope this answers your question :)
@patanchanbaasha811
@patanchanbaasha811 2 жыл бұрын
Thanks for the explanation. Can you please help me to provide the LINQ query for non duplicate rows ?
@patanchanbaasha811
@patanchanbaasha811 2 жыл бұрын
@Let's Automate!! can you please reply on this
@letsautomate2701
@letsautomate2701 2 жыл бұрын
Hey!, Im sorry for late response. I will make a video on this and will upload soon
@patanchanbaasha811
@patanchanbaasha811 2 жыл бұрын
@@letsautomate2701 thank you 😊
@madhavanrao3626
@madhavanrao3626 2 жыл бұрын
Hi, please explain with simple syntax first, then proceed with complex queries.. It's pretty hard to follow your coding as you are super fast....
@letsautomate2701
@letsautomate2701 Жыл бұрын
Sure I will
@madhavanrao3626
@madhavanrao3626 2 жыл бұрын
Thanks a lot for video on linq used in uipath... Please include videos on how to highlight/ remove duplicates in excel using uipath linq queries... 👏👏👏
@letsautomate2701
@letsautomate2701 Жыл бұрын
Will upload soon
@divyabhat1812
@divyabhat1812 2 жыл бұрын
Please do more videos on LINQ. Your LINQ videos are amazing
@letsautomate2701
@letsautomate2701 2 жыл бұрын
Will do! And thank you for watching 🤩
@divyabhat1812
@divyabhat1812 2 жыл бұрын
thanks much needed this
@letsautomate2701
@letsautomate2701 2 жыл бұрын
Your welcome 🙏
@sumitpaithankar1881
@sumitpaithankar1881 2 жыл бұрын
Lets say we have 3 columns "Name", "Age" and "phno". then how to get all 3 columns by checking "name" and "age" only for Non duplicate data after using dt.AsDataview.ToTableview(True, "Name", "Age")
@letsautomate2701
@letsautomate2701 2 жыл бұрын
If you want to get all 3 columns non duplicates, you need to either provide all 3 column in ‘Asdataview’ or use LINQ, Sorry for delay response, i was dealing with health issues
@HarishKumar-ur2to
@HarishKumar-ur2to 2 жыл бұрын
U explanation is good keep on doing
@letsautomate2701
@letsautomate2701 2 жыл бұрын
Thank you
@HarishKumar-ur2to
@HarishKumar-ur2to 2 жыл бұрын
Are u from banglore
@letsautomate2701
@letsautomate2701 2 жыл бұрын
Yes im from Bangalore
@samsammy8313
@samsammy8313 3 жыл бұрын
Good one 😀
@letsautomate2701
@letsautomate2701 3 жыл бұрын
Thank you sam 😀
@preethi7168
@preethi7168 3 жыл бұрын
Thank you for this video. I was looking for this from 3 days. your video really helped!!
@letsautomate2701
@letsautomate2701 3 жыл бұрын
Glad to hear that! Happy to help😊
@preethi7168
@preethi7168 3 жыл бұрын
Hey 👋 first of all let me congrats you on your first video 🤭 And now back to the reason I wanted to add comment here is I was been dealing with same issue , I think with this, it helps me. Let me try this . Thanks again!!
@letsautomate2701
@letsautomate2701 3 жыл бұрын
Hey there!, Thanks for the wishes!!. and sure!! Please try and let me know if you face any challenges :)