+ Reply to Thread
Results 1 to 28 of 28

Code-Visibility vs. Traffic

  1. #1
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Code-Visibility vs. Traffic

    I'm not quite sure if this fits in as an Issue, an Improvement or a Water Cooler comment, but when did the forum get updated so that you must be logged in to view code?

    I know I never would have found ExcelForum.com if it had not have been for a google search on an obscure piece of code I needed, and I was wondering if there was maybe a downward trend in traffic as the search engine's cache gets depleted or if google was special in some way so that their indexer still has access to the code...

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Code-Visibility vs. Traffic

    This condition has been in force since a long time. If a non-registered user wants to view the code, he must be logged in to view it. So he will need to register and view the code.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    oh, thank you. I guess I just hadn't noticed since I'm not used to being logged off so often.

    But then does google still have access to the code, or do I need to use the forum's search tool to pickup code matches?

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Code-Visibility vs. Traffic

    I think google should have access to the code, but for you to view it, you will need to login to the forum. That is, when you search in google and it shows you this forum's threads in the search results, you will need to login to the forum to view that code.

  5. #5
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    I definatly agree, that is what it should do. Do you mind if I post a CODE block in this thread to try and see if google picks it up within the next few weeks?

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Code-Visibility vs. Traffic

    Yeah sure you can try it.

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Code-Visibility vs. Traffic

    I'd be amazed if google can see code. It will just see he questions and responses

  8. #8
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    I know this is not an end all be all test, but it should hopefully at least get which direction the wind is blowing. I propose the following two random phrases which currently have a low hit rate on Google. One inside a CODE block the other outside; now I would assume that the one outside gets picked up faster than the one inside, and moreover if Google doesn’t have visibility to the code then that one shouldn’t be picked up at all (as long as it stays within a code block…).

    Please Login or Register  to view this content.
    Outside code phrase: Srxfcz745892

  9. #9
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Code-Visibility vs. Traffic

    Hi Gregor

    If you were to do a Google Search on "Code-Visibility vs. Traffic" you'll get a hit. If you do a Google Search on " Srxfcz745892" I'll be surprised if you ever get a hit.

    Just my guess.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  10. #10
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    Oddly enough Google caches all kinds of random things: BK100FS270R, so far I still believe it's more of a matter of when as opposed to if Srxfcz745892 will get cached.

  11. #11
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Code-Visibility vs. Traffic

    Hi Gregor

    Perhaps...I've not tested that...I assume you are. Please report back if you will.

  12. #12
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    I did plan to keep an eye out over the next few days to see about how long it took, and will post back although someone else may hopefuly beat me to it with a more accurate time. I would assume around a week since we know that "Code-Visibility vs. Traffic" took at least that long; however it may be longer if the re-cache time is longer than the original discovery cahceing.

    Google Link: https://www.google.com/?gws_rd=ssl#q=Srxfcz745892
    Last edited by Gregor y; 09-08-2014 at 08:02 PM. Reason: add google link

  13. #13
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Code-Visibility vs. Traffic

    The outside phrase hits now, inside doesn't.
    Entia non sunt multiplicanda sine necessitate

  14. #14
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    Odd I cleared my local machine's internet cache, and I'm still drawing a blank. I wonder if we may be hitting a different Google server...

  15. #15
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Code-Visibility vs. Traffic

    I too get a hit on Srxfcz745892

  16. #16
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    I'm picking it up now too, still nothing on the other though.

  17. #17
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    Although I'm wondering if google may have had help since none of the others I've looked at have picked it up yet... Yahoo, HotBot, Bing, ...

  18. #18
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Code-Visibility vs. Traffic

    I got both
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  19. #19
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    Aparently I have the slow version of Google, becuse I'm still not picking up the inside phrase. However Bing is now hitting on the outside phrase.
    Last edited by Gregor y; 09-11-2014 at 08:31 PM. Reason: clarify which bing is hitting on.

  20. #20
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Code-Visibility vs. Traffic

    I'm not picking the inside phrase either. Has anyone else other than xladept got the inside one too?

  21. #21
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Code-Visibility vs. Traffic

    Quote Originally Posted by jewelsharma View Post
    Has anyone else other than xladept got the inside one too?
    Not picking for me too..

    May be xladept should upload a screenshot of the google search result I think


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  22. #22
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Code-Visibility vs. Traffic

    I'm not getting QRVZVc215396 now

  23. #23
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    Quote Originally Posted by xladept View Post
    I'm not getting
    Please Login or Register  to view this content.
    now
    well there went that experiment.

  24. #24
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Code-Visibility vs. Traffic

    Unless someone's given the google bot login permissions, there's no way they could see the code. Google also take a dim view on showing them content that requires users to be logged in to see, I seem to think that Experts Exchange got "done" for that a while ago.

  25. #25
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Code-Visibility vs. Traffic

    although since this thread is in the "Sugestions for Improvement" section I guess I do have a sugestion:

    Add an additional text field to the database table that stores the code, then run a query that updates said field with an alphabetized version of the code with duplicate words removed (excluding at least comments and strings). Then add to the forum code that will pick up this extra field and build out the keywords meta tags.

    That should make the code indexable with out being "visible"...

  26. #26
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Code-Visibility vs. Traffic

    @ Gegor

    Log out of the Forum then do a Google Search on Srxfcz745892. You'll find the hit but, I believe, you'll be asked to log in to see the Code Block.

    I know, in my testing, that's what happens.

  27. #27
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Code-Visibility vs. Traffic

    Just to set the record straight - I think that I googled the one starting with B instead of Q - and I'm sorry for the missstatement

  28. #28
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Code-Visibility vs. Traffic

    Google see the page different to you, they see the source code and vbulletin forums have an IF condition to allow search engines to see things that guests cannot see.
    Not all forums are the same - seek and you shall find

+ 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] Cannot set worksheet visibility in VBA
    By perrja4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 11:30 AM
  2. Traffic
    By NBVC in forum The Water Cooler
    Replies: 3
    Last Post: 04-28-2010, 02:25 PM
  3. Visibility and Locking
    By Lunnmb in forum Excel General
    Replies: 4
    Last Post: 09-16-2009, 07:51 AM
  4. Modify command button visibility with vba code according to user
    By Dolemite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2006, 06:12 PM
  5. Traffic Lights
    By Pedro Serra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2006, 08:10 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