CHECK YOUR INBOX FOR THE FIRST VBA & MACRO LESSON
You will receive your first Excel lesson in your email
from me shortly titled:
[VBA Tutorials] Welcome to the first VBA Tutorial
Make sure to CHECK YOUR SPAM OR JUNK FOLDER
(or “promotions tab” for gmail accounts) in case you don’t see it soon.
CHEERS & HAPPY PROGRAMMING :)
RYAN WELLS
Hi John,
You sessions and the materials posted regularly are very useful. Keep on posting new stuff.
Hi Raymond,
Happy that it’s helpful for you. We will continue to post new Excel tutorials for you so keep posted for updates!
Kind Regards,
Bryan
would like to learn more advanced excel (for accountants)
pivot tables, macro, vba, advanced formulas
Hi Paul, you can learn more about Excel VBA and Macros here: https://www.myexcelonline.com/category/macros/
For Excel Pivot Tables, you can check them out here: https://www.myexcelonline.com/category/pivot-tables/
Need to be expert in Excel… VBA / Macros, Pivot, Analayze
Hi Sandeep, any topics you want to learn on Excel VBA, Macros, or Pivot Tables?
Simply the best site available online to upskill in all aspects of Excel. I’ve learned so much from all the folk here!
Hi John, thank you for the feedback and we will continue to make you better in Excel!
Hi John,
Ample of materials which made me to fall in love to learn excel, I always follow your website to enhance my knowledge on excel.
Thank You. 🙂 🙂
Im glad that you are getting better at Excel Nanda!
Keep on EXCELling 🙂
Cheers,
John
Hi Ryan Thanks, Looking forward to the Lessons
We are happy to have you on board and learning VBA & Macros with us.
Cheers,
John
Looking forward to a new and exciting skill.
Hi Ryan !
It’s very great ! thank you !
Hi Ryan,
It’s an awesome welcome letter. Thank you.
Hope we will have nice learning curve. Mean while if you have any innovative or automotive macro files, could you please share with me.
Hi Santosh,
Are you looking for automotive (like a car) or automated?
DonW
Thank you for all that you do and all that you so freely give to us.
Respectfully,
Peter
You are most welcome Peter 🙂 Keep on EXCELling!
Cheers,
John
Hi ,
I am project manager in automotive firm .need to learn more in dashboard presentation on reports of project progress. kindly suggest a course
Hello Rajagopalan,
This is the best Excel Dashboard Course out there: Mynda’s Dashboard Course
Thanks,
John
Hi Ryan,
I am getting the following message from Comodo Safe DNS when I try to access wellsr.com
Warning: Unsafe Website Blocked!
wellsr.com
This website has been blocked temporarily because of the following reason(s):
Malware: Site may contain content that is harmful, illegal, or malicious to your computer
Go back to safety (Recommended)
This website has been reported as unsafe by various users and we do NOT recommend you to continue browsing.
Disregard this warning and continue (Not Recommended)
Hi Marc,
That may be due to your web firewall being over protective.
I can assure you that wellsr.com does not contain any malware and it is very safe to browse.
Thanks,
John & Ryan
Hi Ryan,
I have just found you and I have signed up for your tutorials. I work with Excel daily to generate daily, weekly, monthly and other ad hoc reports. Most of my data is gotten from PDFs. There is a lot of repetitive manual work that I feel can be done more efficiently.
Any suggestions or tips?
Thanks
Hi, Tade!
Just like with Internet Explorer, it can be challenging to reliably extract data from PDFs. A solution that works for one PDF may not work for another – even if both PDFs look identical! It can be a real mess. The best way to extract data using VBA would be to do it from the file that generated the original PDF. Do you happen to have access to the source file for the PDF, like a .txt file or a .doc file?
Thank you,
Ryan Wells
Hi Ryan,
First of all Congratulations on all your success and effort you guys take in creating this videos :).
I am really interested in learning VBA for excel and automating spreadsheet to link to internet explorer and inputting and retrieving data from any specific website.
I usually do that on a regular basis to generate reports and data analysis on a weekly basis and I would love to cut down on manual labor hours I have to put in day in and day out. would love to hear from you !
Cheers
Steven Rodrigues
Hi Steven,
VBA sounds like the perfect tool to help you automate your report generation! I love using VBA to cut down on manual labor:) How you scrape data from the websites depends heavily on the formatting of the website.
• If you’re pulling in a table from a website, you can do it by creating a data connection from the web.
• If you plan on interacting with the website, like filling in forms and clicking buttons, this can usually be done with some HTML parsing.
• If the website relies heavily on scripts like javascript, it might be quite challenging to build a reliable VBA macro that pulls the data.
Is there a particular website you’re trying to extract the data from? I’ll be happy to point you in the right direction!
Thanks,
Ryan Wells
