 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2007Removing HTML from EXCEL?
Downloaded some HTML spreadsheets from a webpage. I cannot seem to rid those LINKS from it inside EXCEL. Is their some shortcut to doing this? If not, I have MANY hours ahead of me, thank you very much.... > Downloaded some HTML spreadsheets from a webpage. I cannot seem to rid > those LINKS from it inside EXCEL. Is their some shortcut to doing > this? > > If not, I have MANY hours ahead of me, thank you very much.... Very simple! Use this subroutine: --- Sub RemoveLinks() Dim H As Hyperlink For Each H In ActiveSheet.Hyperlinks H.Delete Next End Sub --- Regards, B. >> Downloaded some HTML spreadsheets from a webpage. I cannot seem to rid >> those LINKS from it inside EXCEL. Is their some shortcut to doing [quoted text clipped - 17 lines] > >B. Please humor me some more, where do I place such "code"? > Please humor me some more, where do I place such "code"? Huh... 1) Tools / Macro / Visual Basic Editor (or simple Alt+F11) 2) When in editor, Insert / Module 3) Paste code 4) File / Close and return to Microsoft Excel (Alt-Q) Call the subroutine with Alt-F8, select RemoveLinks and click on Run button. If you don't want to have any macro related warnings after you save the file, go back to Visual Basic Editor and choose File / Remove Module1 (or some other module name if you changed it). :) B. >> Please humor me some more, where do I place such "code"? > [quoted text clipped - 15 lines] > >B. WOW talk about hard ;-) One missed step and WHAM! Thanks for the detailed baby steps! Have a nice evening! >>> Please humor me some more, where do I place such "code"? >> [quoted text clipped - 23 lines] > > Have a nice evening! Sorry if I've missed anything by accident - I had to translate most of the menus from Croatian to English :) BTW. There are only necessary steps - nothing critical would happen if you miss any of all FOUR steps :) B. >>>> Please humor me some more, where do I place such "code"? >>> [quoted text clipped - 31 lines] > >B. LOL, I am native English. I could BARELY translate a few lines of Spanish to you with a gun to my head. I'll be sure to send you a labor day card next year, made by hand ;-) I like the approach that I first saw in a reply by Dave Peterson. Select all the cells with the hyperlinks (if you have just pasted them in to your sheet then they will already be highlighted). Then press Alt-F11 to bring up the Visual Basic Editor. Then press CTRL-G to go into the Immediate Window. Then type: selection.hyperlinks.delete (Enter) Hey presto! They've all gone. Close the VBE window to get back to your sheet. Hope this helps. Pete > >>>> Please humor me some more, where do I place such "code"? > [quoted text clipped - 38 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.