+ Reply to Thread
Results 1 to 2 of 2

tweak to the attached web crawl worksheet

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    tweak to the attached web crawl worksheet

    in #3 when I say show column D in the dashboard I meant to add only for the sites a match is found
    Attached Files Attached Files
    Last edited by dawondr; 11-22-2015 at 04:10 PM.

  2. #2
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    tweak to the attached web crawl worksheet

    I’m hoping I can get someone’s assistance with the attached. I actually need help with three things but I think number three might require me to open a new ticket which is OK.
    Attached I have a spreadsheet that I found on this site that I tweaked a little. It will go out to websites and crawl looking for key words. Presently I have a row for each key word so I have Toys-Are-US 5 times with the same website but with 5 different keywords. Can I search multiple keywords? I don’t really care if they have Toy A and not toy B, C, or D once I know they have one of the ones I am looking for I will go to that website and look to see what it found. So my 3 requests for help are:

    1. Can I have just one website and search multiple keywords (not the end of the world if I can’t)
    2. The Excel sheet it set to use Internet Explorer, can that be changed to use whatever your default browser is? (if not set to default and it needs a browser to be called out can it be changed to Chrome?) Default preferred Chrome 2nd choice
    3. This is the one I believe I may need to open a new ticket in a different Excelforum type. This is crude looking, any nice little dashboard that can be made on a different TAB? Have it say how many unique websites it is set up to check, how many unique keywords and maybe list column D which is the site identifier? If I make the name in column D a hyper link to the page would that carry over to the dashboard page? for lines that have a match, toy is found?

    Thanks in Advance,
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Tweak formula to work again after changing worksheet
    By opusarlo in forum Excel General
    Replies: 1
    Last Post: 03-30-2015, 08:07 PM
  2. Need a tweak to worksheet change code that autofits the row height of merged cells
    By David M. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2014, 01:33 PM
  3. Crawl Sheets with Macro
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 08:57 AM
  4. [SOLVED] VBA code suddenly slows Excel to a crawl...
    By Taemex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2013, 11:46 PM
  5. Code for filling (worksheet attached)
    By lpratt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2010, 02:04 AM
  6. Replies: 3
    Last Post: 03-09-2007, 05:11 AM
  7. VB Slows to Crawl when Deleting Rows
    By forbesy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2005, 11:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1