Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 April 2021

Top 3 Topics with Most Views

Delete multiple CSV or Excel columns and column range made by @markosc with 31 views.

Extract working date made by @Amin with 31 views.

ジョブを実行する際にロボットを選択できない。 made by @smochidolphine with 31 views.

Top 3 Topics with Most Replies

Copy Range Keeping Formulas made by @sereganator with 10 replies.

Today's Date Coming Wrong Suddenly(Project Notebook -> Date Sheet ) made by @ayewale with 10 replies.

Start Process activity, how to best wait for completion made by @rogerfries with 9 replies.

Top 3 Users Who Posted The Most

@alexandretperez made 14 posts!

@ppr made 11 posts!

@prasath17 made 11 posts!

Top 3 Most Liked Posts

This post made by @MBSHansen received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, my name is Mikkel and I joined as I am currently going through the UiPath RPA Associate Certification Training, and have a few questions to optimize the way i build my workflows. I am looking forward to learning with all of you.

This post made by @wasea received 2 likes!

Chrome Save As

Hi @Minol_Pamosha , If it’s related to the file path, you can put it in the file name and it will save the file at the new path. Not needed to change the path from the upper address bar. Something like this: [image] Just an idea. Vasile.

This post made by @SIM_JUN_HUI_BERTRAM_CSOD received 2 likes!
https://forum.uipath.com/t/311365/6

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Excel splitting a column value to multiple columns

@bhishaj Welcome to the forum give a try on doing the extraction with the help of regex e.g. [grafik] [grafik] [grafik] [grafik] etc. Also have a look here:

This solution provided by @prasath17 received 1 likes!

Convert excel column to 2 decimal places

@Yudhisteer_Chintaram1 - After using “MidpointRounding.AwayFromZero” issue has fixed… Math.Round(cdbl(row("NW Elasthane")),2,MidpointRounding.AwayFromZero).ToString("N2")) Please see the ouput below: [image]

This solution provided by @prasath_S received 1 likes!

Delete multiple CSV or Excel columns and column range

You can use invoke VBA activity for this, Do this one time on excel, In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box). Put the code on text file, Sub macro() Range(“AC1”).entirecolumn.delete Range(“CM1”).entirecolumn.delete Range(“CO1”).entirecolumn.delete Range(“CQ1”).entirecolumn.delete R…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.