Excel VBA/Macro Help

[Walker_Ice]

Hi Everyone,

I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can write a script to automatically import all of the appointments every time I open the workbook? I have never written code for Excel, any help and guidance is greatly appreciated.

Information Needed:
Client First Name & Last Name.
Client Phone #
Client Email Address
Client Appointment Type
Client Appointment Date/ Cancelations


Thank you for your help!

 

[rlv01]

What you want to do is known as web scraping. If you search this forum for thread titles with the word "scraping" in them, you will find a lot of threads on that topic.

 

[Walker_Ice]

I will research this topic and work on trying to get this function to work.