bubke 0 Posted December 1, 2010 Hi, Is there someone who could help me with converting Excel text cells in cells with hyperlinks? I've many hyperlinks in Excel in a column, but they are in text format. What I want is that the links are clickable, so that they open in a browser. I don't have many experience with Office in combination with autoit. Maybe there is someone who has an example script. Any help is very welcome! Thank you Share this post Link to post Share on other sites
water 2,391 Posted December 1, 2010 Please hava a look at the Excel UDF function _ExcelHyperlinkInsert: Inserts a hyperlink into the active page. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
JoHanatCent 13 Posted December 1, 2010 (edited) Maybe there is someone who has an example script. Any help is very welcome! This is just that. An Example. Please test before using it. #include <Excel.au3> $Count = 0 $oExcel = _ExcelBookOpen(@DesktopDir & "\Book.xls", 0);0 = file not visible $Count = $oExcel.Worksheets(1).Usedrange.Rows.Count For $i = 1 To $Count $sCellValue = _ExcelReadCell($oExcel, $i, 2);row = $i number, col = 2 (B) _ExcelHyperlinkInsert($oExcel, $sCellValue, $sCellValue, $sCellValue, $i, 2) ;Correct use: ;_ExcelHyperlinkInsert($oExcel, $sLinkText, $sAddress, $sScreenTip, $sRangeOrRow [, $iColumn = 1]) Next _ExcelBookClose($oExcel) $oExcel = _ExcelBookOpen(@DesktopDir & "\Book.xls", 1);1 = file is visible Edited December 1, 2010 by JoHanatCent Share this post Link to post Share on other sites
bubke 0 Posted December 3, 2010 This is just that. An Example. Please test before using it. #include <Excel.au3> $Count = 0 $oExcel = _ExcelBookOpen(@DesktopDir & "\Book.xls", 0);0 = file not visible $Count = $oExcel.Worksheets(1).Usedrange.Rows.Count For $i = 1 To $Count $sCellValue = _ExcelReadCell($oExcel, $i, 2);row = $i number, col = 2 (B) _ExcelHyperlinkInsert($oExcel, $sCellValue, $sCellValue, $sCellValue, $i, 2) ;Correct use: ;_ExcelHyperlinkInsert($oExcel, $sLinkText, $sAddress, $sScreenTip, $sRangeOrRow [, $iColumn = 1]) Next _ExcelBookClose($oExcel) $oExcel = _ExcelBookOpen(@DesktopDir & "\Book.xls", 1);1 = file is visible Thank you for your help, you set me on the right path! Share this post Link to post Share on other sites
PsaltyDS 39 Posted December 3, 2010 For a particular Excel hyperlink, you can set the property directly: $oExcel.ActiveSheet.Hyperlinks(1).TextToDisplay = "Link text here" Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Share this post Link to post Share on other sites