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....

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.

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"?

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.

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!

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.

Removing HTML from EXCEL?
 

On Thu, 20 Sep 2007 23:51:46 +0200, Boris sayd the
following:

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.


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 ;-)

Removing HTML from EXCEL?
 

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


On Sep 20, 11:21 pm, Crackles McFarly wrote:
On Thu, 20 Sep 2007 23:51:46 +0200, Boris sayd the
following:





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.

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 ;-)- Hide quoted text -

- Show quoted text -