Web Sites (EXCEL)

Trusted Web Sites

The following web sites 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.

  1. http://www.ozgrid.com
  2. http://www.j-walk.com
  3. http://spreadsheetpage.com/
  4. http://www.dailydoseofexcel.com
  5. http://www.dicks-clicks.com
  6. http://www.andypope.info
  7. http://www.excelkb.com
  8. http://www.exceluser.com/cmd.php?af=1140562
  9. http://www.exceltip.com
  10. http://cpearson.com/excel.htm
  11. http://www.tushar-mehta.com/excel/
  12. http://peltiertech.com/
  13. http://www.excelguru.ca
  14. http://www.mvps.org/dmcritchie/excel/excel.htm
  15. http://www.oaltd.co.uk/Default.htm
  16. http://www.contextures.com/index.html
  17. http://codematic.net/default.htm
  18. http://www.jkp-ads.com/index.asp
  19. http://www.xtremevbtalk.com
  20. http://www.ronDebruin.nl
  21. http://www.blueclaw-db.com/
  22. http://www.xcelfiles.com
  23. http://www.excelforum.com
  24. http://vangelder.orconhosting.net.nz/excel/
  25. http://www.brainbell.com/tutorials/ms-office/excel/
  26. http://www.excelhero.com
  27. https://fastexcel.wordpress.com/
  28. http://datapigtechnologies.com/blog/
  29. http://chandoo.org/wp/
  30. http://www.msofficegurus.com.br/

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

  1. http://www.dicks-blog.com
  2. http://www.DailyDoseOfExcel.com

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.

  1. http://www.google.com
  2. http://www.google.ca
  3. http://groups.google.com


  1. http://msdn.microsoft.com/office/program/excel/
  2. http://www.office.microsoft.com
  3. http://www.support.microsoft.com
  4. http://msdn.microsoft.com/en-us/library/aa272254(office.11).aspx
  5. 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.



9 thoughts on “Web Sites (EXCEL)”

    1. 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.

  1. 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?


    Best Regards,


    Christopher T. Fennell
    President, Business Consultant/Developer
    Excel and Access, LLC®

    1. 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

    2. 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

      1. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s