+ Reply to Thread
Results 1 to 9 of 9

I have the codes for different commands be done but i need to combine them into one

  1. 04-02-2014, 09:58 PM #1
    RobinPrice
    RobinPrice is offline
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    I have the codes for different commands be done but i need to combine them into one

    Hi everyone,

    I have the codes for different things to be done but i need to combine them into one

    Very grateful for all your help

    Thanks
    Robin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-02-2014, 10:29 PM #2
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: I have the codes for different commands be done but i need to combine them into one

    Hello,

    Here's a proposal : 

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
    Reply With QuoteRegister To Reply
  3. 04-02-2014, 10:32 PM #3
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: I have the codes for different commands be done but i need to combine them into one

    Hello RobinPrice,

    After a quick look at the workbook, I think it would be easier to edit all this by creating a temporary HTML file from the worksheet data and then open the document in VBA. You can then use the built properties and collections of HTML document to modify the text.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  4. 04-02-2014, 11:35 PM #4
    RobinPrice
    RobinPrice is offline
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: I have the codes for different commands be done but i need to combine them into one

    Hi GC Excel,

    the macro worked a breeze brilliant but I forgot to mention one more thing i needed the images to be removed from the description I will upload the same file with the codes in it

    Thanks
    Robin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 04-02-2014, 11:53 PM #5
    RobinPrice
    RobinPrice is offline
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: I have the codes for different commands be done but i need to combine them into one

    Hi Leith Ross'

    the macro worked a breeze brilliant but I forgot to mention one more thing i needed the images to be removed from the description I will upload the same file with the codes in it the file is uploaded below

    Thanks
    Robin
    Reply With QuoteRegister To Reply
  6. 04-03-2014, 08:53 AM #6
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: I have the codes for different commands be done but i need to combine them into one

    Hi robinprice,

    Try this modified code : 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-04-2014, 07:14 PM #7
    RobinPrice
    RobinPrice is offline
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: I have the codes for different commands be done but i need to combine them into one

    Hi GC Excel,

    the macro worked except it did not remove the img alt

    Thanks
    Robin
    Reply With QuoteRegister To Reply
  8. 04-04-2014, 10:40 PM #8
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: I have the codes for different commands be done but i need to combine them into one

    Hi,

    This one will delete <img alt

    Note that in the code you had, <br /> are removed if any reference to youtube is found.
    The code below will also remove <br /> if <img alt= is found

    Let me know if you need to keep the <br /> or not...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 04-04-2014, 11:16 PM #9
    RobinPrice
    RobinPrice is offline
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: I have the codes for different commands be done but i need to combine them into one

    Hi GC Excel,

    the macro worked excellent all stations go

    if you have the time can you have a look at this one
    http://www.excelforum.com/excel-prog...-into-one.html

    Thanks
    Robin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do i combine two codes to run together
    By Sam2149 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2014, 05:42 PM
  2. Combine 2 codes
    By Minhaz.iubat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2014, 05:46 AM
  3. [SOLVED] How to combine these two set's of codes?
    By aadeshgandhi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2013, 07:26 PM
  4. combine codes
    By Oeysbrei in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-30-2012, 03:38 AM
  5. Combine vba codes
    By mmwltd in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-22-2010, 08:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1