ask analystcave

Contact AnalystCave

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Want to suggest a Partnership or request a service or just reach out to me in general?
Contact me directly: analystcave (at) gmail.com.

If you have questions or want to report bugs etc. please refer to my Ask a Question page or comment on my posts instead.
I do not reply to such questions via email

6 thoughts on “Contact AnalystCave”

  1. You have interesting functions on your site for calculating the distance between two cities.

    However, NOTHING that I’ve searched for does what I’m looking for.  I have an Excel sheet with zip codes as well as city and state names as well as their long. and lat. values.  I want to know the DRIVING distance between two locations.  Not as the crow flies which I can calc using trig, but however Google calculates it.

    Every site I find says this can be done, but there’s no clear macro posted anywhere to do this in Excel.  Can you help?

     

    Kevin

      1. Hey AnalystCave,

        I recently learned about your awesome features for excel, particularly the Scrape HTML add-on.

        I currently use another add-on, SEO tools, but I find that it is not the most dynamic feature for what I need.

        I work as an SEO project manager for Marriott, and all of my issues derive from the fact that the team I build scrapes for has to use Excel for reporting purposes.

        I am trying to scrape text after tags among other requests.

        I started working with the getelementbyregex as this seems to be the most precise request I can write, but when I use your Regex Tester and click copy regex to “” it does not insert the unique regex but the generic regex I used to find all of the tags (([^*]*?)). Any help would be great, If I can find a permanent replacement for SEO tools, I could definitely see myself making a nice donation to your site.

        Thankyou
        Andrew

Leave a Reply

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match