Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 January 2024

Top 3 Topics with Most Views

Change Date Format(MDY)to(DMY) made by @MD_Farhan1 with 48 views.

Re-arrange excel sheet order made by @KSK_R_D with 46 views.

Chrome and Edge have error ERR_SSL_KEY_USAGE_INCOMPATIBLE but Firefox is normal made by @irahmat with 42 views.

Top 3 Topics with Most Replies

Change Date Format(MDY)to(DMY) made by @MD_Farhan1 with 23 replies.

Replace Column one Excel to another Excel made by @MD_Farhan1 with 23 replies.

Delete Column made by @MD_Farhan1 with 19 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 54 posts!

@MD_Farhan1 made 35 posts!

@Anil_G made 26 posts!

Top 3 Most Liked Posts

This post made by @yt.yutao received 2 likes!

Excel里的一列数据复制到邮件正文

Hi @mkankatala , Thank you for your help. BRs Banksy

This post made by @vrdabberu received 1 likes!

Re-arrange excel sheet order

Hi @KSK_R_D You can use this Invoke VBA code: New Text Document.txt (1.1 KB) Workflow: [image] Input: [image] Output: [image] Regards

This post made by @rikulsilva received 1 likes!

For each File (Upload Files to a tool)

Hi @lo86 is it possible to add a new column to excel that represents the full path of the file that you want to upload? If so, in for each row you will have the desired file path. To upload the file depends the destination application but in general you can use Click and Type Into activity, passing the full path of the file that can be already populate in source excel file

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

Re-arrange excel sheet order

Hi @KSK_R_D You can use this Invoke VBA code: New Text Document.txt (1.1 KB) Workflow: [image] Input: [image] Output: [image] Regards

This solution provided by @vrdabberu received 1 likes!

Text format in mail

Hi @saikumar.velma Use the Get Attribute activity in the modern activities and it works!! Regards

This solution provided by @vrdabberu received 1 likes!

Delete Column

Hi @MD_Farhan1 I hope you have given both the column names in the same activity. Remove data column works only for a single column at a time so if you want to remove 2 columns then please use 2 remove data column activities and that works!! Regards

---

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.