akalie Posted February 19, 2012 Share Posted February 19, 2012 (edited) good daytime, everyone! how to paste a string from clipboard as a hyperlink? (I have a lot of work in Excel with files). I tried "clipboard.au3" but I didn't find URL format in it Thanks! ps sorry my English Edited February 19, 2012 by akalie Sorry my English)) Link to comment Share on other sites More sharing options...
qsek Posted February 19, 2012 Share Posted February 19, 2012 Since excel has his own clipboard i dont know what is used originally, but it seems like a link in html format is being inserted right in excel. Teamspeak 3 User Viewer - Quick and functional TS3 Query script, which shows online users.Cached Screenshot Deleter - Deletes older Fraps Screenshots if they exceed a specified limit.Unresolved Topics:Intercept and modify dragdrop text behaviour in scite Link to comment Share on other sites More sharing options...
akalie Posted February 19, 2012 Author Share Posted February 19, 2012 Thanx for reply, but it's not that simple. I need a link to file. about excel's own clipboard, then I copy adress from browser, it pastes in Excel as a link. But from Notrbook as a row text. Sorry my English)) Link to comment Share on other sites More sharing options...
qsek Posted February 19, 2012 Share Posted February 19, 2012 wow i must have read that text from you over 10 times and im still not sure what your problem is. But just in case you copy the link from the adress bar: This is not html format, its plain text. Therefore in excel it will paste plain text ,too. You have to convert the link to the format: <HTML><A HREF="C:FolderFile.txt">Link text</A></HTML> Teamspeak 3 User Viewer - Quick and functional TS3 Query script, which shows online users.Cached Screenshot Deleter - Deletes older Fraps Screenshots if they exceed a specified limit.Unresolved Topics:Intercept and modify dragdrop text behaviour in scite Link to comment Share on other sites More sharing options...
akalie Posted February 19, 2012 Author Share Posted February 19, 2012 I just try to paste exactly that "<HTML><A HREF="C:svf_info.txt">Link text</A></HTML>" in a cell, and the same string displayed. Not a link (i tried with exsisting files)sorry for "read that text from you over 10 times")), i'm not really good in english. what I need is script like this:you select the file(it might be on a fileserver)hotkey #1open Excel, select cellhotkey #2profit!!!!1!1! (hyperlink to a file in the cell) Sorry my English)) Link to comment Share on other sites More sharing options...
akalie Posted February 19, 2012 Author Share Posted February 19, 2012 i made some lame replacment on a hotkeys (ctrl-k for hyperlinks in excel), but the simple $path = clipget() didn't work with files from local web, so in that case i haven't file adress. I sow something about different fields in clipboard entry, will try to dig where Sorry my English)) Link to comment Share on other sites More sharing options...
qsek Posted February 19, 2012 Share Posted February 19, 2012 (edited) I just try to paste exactly that "<HTML><A HREF="C:svf_info.txt">Link text</A></HTML>" Yeah it seems that if you copy the code from the website, its converted into "html text" which excel recognises as text and not html code. Try open notepad and paste the code from the website there, then select and copy the code in notepad again and excel makes a link out of it codewise you can use ClipPut: Local $bak = ClipGet() MsgBox(0, "Clipboard contains:", $bak) ClipPut("<HTML><A HREF='"&$bak&"'>Link text</A></HTML>") MsgBox(0, "Convert into HTML Link:", ClipGet()) Edited February 19, 2012 by qsek Teamspeak 3 User Viewer - Quick and functional TS3 Query script, which shows online users.Cached Screenshot Deleter - Deletes older Fraps Screenshots if they exceed a specified limit.Unresolved Topics:Intercept and modify dragdrop text behaviour in scite Link to comment Share on other sites More sharing options...
akalie Posted February 19, 2012 Author Share Posted February 19, 2012 thank you!!! it's work!)) I almost started c++ research about it. Sorry my English)) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now