Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing 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.... |
#2
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing HTML from EXCEL?
On Thu, 20 Sep 2007 16:44:05 -0400, Crackles McFarly wrote:
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. |
#3
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing HTML from EXCEL?
On Thu, 20 Sep 2007 23:32:38 +0200, Boris sayd the
following: On Thu, 20 Sep 2007 16:44:05 -0400, Crackles McFarly wrote: 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. Please humor me some more, where do I place such "code"? |
#4
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing HTML from EXCEL?
On Thu, 20 Sep 2007 17:37:55 -0400, Crackles McFarly wrote:
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. |
#5
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing HTML from EXCEL?
On Thu, 20 Sep 2007 23:43:44 +0200, Boris sayd the
following: On Thu, 20 Sep 2007 17:37:55 -0400, Crackles McFarly wrote: 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. WOW talk about hard ;-) One missed step and WHAM! Thanks for the detailed baby steps! Have a nice evening! |
#6
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing HTML from EXCEL?
On Thu, 20 Sep 2007 17:49:03 -0400, Crackles McFarly wrote:
On Thu, 20 Sep 2007 23:43:44 +0200, Boris sayd the following: On Thu, 20 Sep 2007 17:37:55 -0400, Crackles McFarly wrote: 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. WOW talk about hard ;-) One missed step and WHAM! Thanks for the detailed baby steps! 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
html and excel | Excel Discussion (Misc queries) | |||
Excel to Html | Excel Discussion (Misc queries) | |||
html to excel | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) |