Results 1 to 5 of 5

Thread: Macro help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macro help

    Hi

    I have 1000 of website links some of them are having Java scripted and some are not.

    i need a macro to identify all the java scripted links.

    thanks for help.

  2. #2
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,808
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: MAcro help

    I have several questions:
    1. Where are these links. You need to say something like in column(A)
    2. You did not say how we can identify a Java scripted link. What is there different in a Java scripted link and any other link

    3.And you said you wanted the Java scripted link identified but did not say how to identify them.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  3. #3
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,805
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: MAcro help

    You prob need to provide more info on what you require !!
    Where are they ??
    What are the ones to be identified ??
    What do you want done to identify them ??
    What do you want to do once they are identified ??
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  4. #4
    New Member
    Join Date
    Feb 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MAcro help

    Quote Originally Posted by My Aswer Is This View Post
    I have several questions:
    1. Where are these links. You need to say something like in column(A)
    2. You did not say how we can identify a Java scripted link. What is there different in a Java scripted link and any other link

    3.And you said you wanted the Java scripted link identified but did not say how to identify them.



    Hi

    All the links are in column A.

    macro to run like this open the link on browser after that open java script by clicking CTRL + U on browser.

    Then search for the links of column A if found report yes or any indicator in column B next to the respective link.

  5. #5
    New Member
    Join Date
    Feb 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MAcro help

    hi

    All the items are of Column A are company website links.

    All the links are in column A.

    macro to run like this open the link on browser after that open java script by clicking CTRL + U on browser.

    Then search for the links of column A if found report yes or any indicator in column B next to the respective link.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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