Convert Hypertext to Text

  • Re: Convert Hypertext to Text


    Here's something I whipped up. One of the experts probably has a quicker more fluent way to do it. But this is functional.

  • Re: Convert Hypertext to Text


    JohnDrew,

    Your workbook VBA is password protected.

    Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

    1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
    2. Open your workbook
    3. Press the keys ALT + F11 to open the Visual Basic Editor
    4. Press the keys ALT + I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
    7. Press the keys ALT + Q to exit the Editor, and return to Excel
    8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.





    Then run the GetLocation macro.


    I would really like to do this with RegExp.

    Have a great day,
    Stan

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!