Thanks @rahulsharma for prompt feedback, probably you didn’t get my point, insertig that objet icon is just at the end, and before that i want my Bot checking for Mp3 files in main folder and once there is a new one it will do the following :
1- Fill file details in excel : Id, Name, Link(Path location)
2- Insert Hyperlink into 3rd column for this path.
3-change the content of this cell which contains a link to an icon or just a clear text, like : “Audio”
4- Save excel file to HTML format, as the one I shared in attached ZIP file.
Checking out for any new file is easily done by path exists.
getting the details and filling in excel - > Basic information can be entered normally fie the field you need to alter, i just suggested to have a template that converts anything added to that colon to your desired format.
Then saving the file as html can be done using move activity or we can create a custom activity to rename and change extension of the file.
Regarding file, I’ll have a look on system and add any further information I can.
As you are adding hyperlink in the excel, that logically means referring to a file in a specified location hence when you click on the icon that navigates to that file and it opens in a new window as it an audio file.
For playing in the same screen in a html page we need to have the
I tried the VBA script that was playing the audio but while we convert the Excel to HHTML file, that VBA does not work as that VBA is a feature of excel file, even you might have seen that popup that some features might be lost if you save Excel as .htm. So I think it will not be possible to have that on the same page as long as we convert it from excel OR may be more R&D is required. Good luck!