Trusted Websites
The following websites provide excellent information, tips, tricks, and solutions to some of the more challenging problems you may encounter using Excel and VBA. We have specifically included sites that have provided or enabled us to develop working solutions that were successfully integrated into our code. They are not listed in any particular order or preference.
- http://www.ozgrid.com
- http://www.j-walk.com
- http://spreadsheetpage.com/
- http://www.dailydoseofexcel.com
- http://www.dicks-clicks.com
- http://www.andypope.info
- http://www.excelkb.com
- http://www.exceluser.com/cmd.php?af=1140562
- http://www.exceltip.com
- http://cpearson.com/excel.htm
- http://www.tushar-mehta.com/excel/
- http://peltiertech.com/
- http://www.excelguru.ca
- http://www.mvps.org/dmcritchie/excel/excel.htm
- http://www.oaltd.co.uk/Default.htm
- http://www.contextures.com/index.html
- http://codematic.net/default.htm
- http://www.jkp-ads.com/index.asp
- http://www.xtremevbtalk.com
- http://www.ronDebruin.nl
- http://www.blueclaw-db.com/
- http://www.xcelfiles.com
- http://www.excelforum.com
- http://vangelder.orconhosting.net.nz/excel/
- http://www.brainbell.com/tutorials/ms-office/excel/
- http://www.excelhero.com
- https://fastexcel.wordpress.com/
- http://datapigtechnologies.com/blog/
- http://chandoo.org/wp/
- http://www.msofficegurus.com.br/
- https://exceloffthegrid.com/blog/
DailyDoseOfExcel featured a portion of our post “Lean Office with Excel and VBA” as a discussion topic. Click here to view Learn VBA to Be Lean.
Trusted Blogs
Google – Simply the easiest way to find what you’re looking for.
Warning – Although VBA code is typically virus free, use caution before using these files to reduce the risk of exposure to malicious content. It is always best to review the code before allowing it to run on your computer.
Microsoft
- http://msdn.microsoft.com/office/program/excel/
- http://www.office.microsoft.com
- http://www.support.microsoft.com
- http://msdn.microsoft.com/en-us/library/aa272254(office.11).aspx
- Manual and Documentation: http://office.microsoft.com/en-us/excel-help/excel-help-and-how-to-FX101814052.aspx?CTT=97
API Viewer
Windows APIs for VBA code by Christoph von Wittich (Christoph@ApiViewer.de): API Viewer Application
Excel MVP’s – Websites
List of Excel MVP’s and their related websites.
Hello,
Please consider adding my Excel blog to your list:
http://excelhero.com/blog
Many people find it extraordinarily useful.
Thanks and kind regards,
Daniel Ferry
excelhero.com
I was aware of your blog and reviewed it again. Your credentials are impressive and your articles feature some very powerful functions with great examples. I trust our visitors will find great value in your site as well.
I am very pleased to add your link to our list of trusted sites and thank you for bringing it to our attention.
I hope that you will also review our site and add it to your list: http://www.GCFLearnFree.org/Excel Thanks!
Thank you for visiting our site! I will review your content as requested.
Hello.
I have an Excel and Access website and Excel and Access blog that has been around for a while now. I started operations in 2003/2004. I have several published authors working with me, as well as professional trainers for Excel, Access, Word, Outlook, and SQL Server. One of my team members teaches advanced Excel VBA at a college near her home. Having several Microsoft MVPs with me means we need to support the Microsoft community and the community of users. Being listed on your site would aid us in those efforts.
May I please be listed on your site?
http://excelandaccess.com/
Best Regards,
Christopher
Christopher T. Fennell
President, Business Consultant/Developer
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
http://www.linkedin.com/in/ExcelAndAccess
Dear Christopher,
I am very glad to know this website . My name’s Trinh from Vietnam. I am working OEE on Excel and finding a software or finding the way to create a program which can calculate OEE for my Factory.
Actually, I’m appreciated to work on Access, Therefore, Please kindly help to instruct me work it .
I am looking forward to receiving your feedback.
Thank you very much.
Trinh Pham
Dear Christopher,
I am very glad to know this website.
My name’s Trinh. I am working OEE via Excel. Hoever, I would like to develop via Access.
Please kindly help to instruct me to create an OEE program by Access,
I am looking forward to receiving for feedback.
Thanks you very much and have a nice day!
Trinh Pham
Hi Trinh, it is possible to migrate your Excel worksheets to an Access database. Of course, this will depend on the structure of your Excel workbook and whether columns are labeled with “Access” compatible naming conventions.
Without knowing how your workbook is setup, it is difficult to offer a detailed migration solution.
We’ll look up some links that may be able to offer you assistance by way of example.
Thank you for visiting.
Sir, 19th June,2021.
I am very impressed and surprise to see such a big and very useful list of WEB Addresses of Excel Topic.
Now I am going to each and every Web site to go deeply to learn more and more.
As and when I proceed further I will comment.
Thanking you very much.
Kanhaiyalal Newaskar.