Posts by S O

  • IE automation VBA drop down list

    Hi Serhito,


    Welcome to OzGrid.


    It looks like you're actually trying to get the list and then go two levels below it in the DOM? You can't use getElementsById because it doesn't have an ID.


    I'd just get the dropdown directly rather than trying to go through child objects in the DOM:


    Code
    1. Set List = ieObj.document.getElementsByClassName("earnings_announcements_earnings_table_length")(0)

  • Please help: automation of email scraping into Excel 365 using hunter.io

    Hi badabing, welcome to OzGrid.


    Unfortunately what your asking is against LinkedIn terms of service:


    Quote from LinkedIn ToS
    • Except as expressly authorized by LinkedIn in writing, use any automated means or form of scraping or data extraction to access, modify, download, query or otherwise collect information from LinkedIn’s websites;


    I will therefore close this thread with a quick reminder to please read any website's ToS before you attempt to do anything like this in future.


    Best regards,


    S O

  • Excel Freebies

    That particular form was disabled deliberately due to some targeted spam attacks, I'll raise the broken links with the owner though - thanks for bringing it to our attention!

  • Excel Freebies

    Hi VWRSue, please can you provide a link to the page you're trying to access and I can give you some further information. Feel free to DM me if easier.


    Many thanks,


    Sam

  • Information for chat area

    With the launch of the new chat section, here are some useful commands and information about the chat in general.


    - Chat feed loads every 3 seconds, so you might see a very small delay between posting and the message appearing. This is deliberate to preserve server processing.

    - Users are automatically marked as "away" after 10 minutes of inactivity

    - There is a maximum message length of 500 characters

    - Messages are automatically archived after 5 minutes

    - Permanent chat rooms can be requested by contacting a forum administrator


    The following commands are available within chat. Where a command requires a username as an argument, double quotes should be used for usernames with spaces.


    - /away sets your status to away

    - /color [name of a colour] changes your username colour in chat

    - /info [username] displays information about that user

    - /whisper [username] [message] sends a message to that user privately


    Have fun!

  • Changing the Status of a thread

    fwiw I see it as entirely optional - as Roy states, it was never a feature that existed previously. If people want to use it then go for it, but there's certainly no obligation to do so :)

  • Formatting of posted code using the </> symbol

    Quote from Mumps

    I have tried that without success. When I open a thread that contains code, it appears without any indentation in that thread even though it was posted with the indentation included. Another problem I'm having is that I cannot manually copy/paste text from one post to another or even within the same post. I'm wondering if the problems are related.

    Mumps/vcoolio,


    Can you provide a screenshot of what you're seeing? Also if you can provide screenshot(s) of what you're copy/pasting vs. what the post renders afterwards that would be helpful.

  • Water Billing Rates Formula

    Hi EvanBerrett, welcome to OzGrid.


    Please update your post with links to the other forums you have asked this question. If you are unable to do so please ask myself or any of the moderators to amend the post for you with the necessary links.


    For more information on this request - please refer to the forum rules (in my signature) which explain what cross-posting is and why we ask you to supply links.


    Many thanks


    Sam

  • Changing the Status of a thread

    Quote from Justin Doward

    So, can I ask what it is I am looking at when I click on the "Unresolved Threads" option? What places a thread in that status?

    Hi Justin,


    The "Unresolved Threads" option is showing threads that do not have a "resolved" status as you probably suspected.


    The ability to mark a thread as "resolved" is something that we've only had for the last year or so. Historically this didn't exist on OzGrid and so for that reason it's never been a requirement on here. If people do decide to do it then it's really just a bonus.


    All the best,


    Sam