How to download a file from this blog?

Click to download the file             Click to download the file

It’s quite simple: just click on one of the above icons. A new window will pop-up asking you to save the file at the hard disk of your computer.

I clicked the icon, but I cannot download the file?
Please retry one or two more times. Sometimes Dropbox links don’t work the first time. If you still cannot download the file, please send me an e-mail and I will probably provide you the file.

I tried to use a file that I downloaded from you site and it doesn’t work, why?
Well, I don’t know! First of all, ensure that your system meets the minimum requirements. Then, send me an e-mail and try to describe the problem or the error you get. File errors are top priority for me. In general, I try to provide you with free working solutions, but, sometimes I might have missed something. So, in case of a file error, I am willing to correct it as soon as possible.

Policy for comments and emails

Why I cannot comment on older posts? Why Disqus keeps showing a “Comments for this thread are now closed” message?
This is due to the new comments policy that I applied (see here for details). Comments will stay open for only 60 days after the post publication.

Hey, Christos, I sent you an email, why I didn’t get an answer?
Honestly, I really like to receive comments and feedback from all of you. However, keep in mind that my free time is quite limited (see here why). So, I would suggest you to review the guidelines below before sending me an e-mail:

  • First of all, check the comments section of the post, and, then, search the blog. The answer you are seeking might lies either within the comments section of the post you read, or to a different post.
  • If you send me an email, try to be specific at your message. Don't send me 100 lines of code and say "It doesn't work". Narrow things down to perhaps 10 lines of code that illustrate the problem. Tell me exactly what the problem is; does the code blow up? Compiler error? Run time error? Incorrect results? Explain what the code should do and what it presently does or does not. Include the exact error message generated and identify the line of code that caused the error.
  • If you include code, make sure it compiles as written. That means declaring all your variables (set Option Explicit on). If I can't paste the code into a module with Option Explicit in effect, I will probably not reply. Sorry, but I'm not here to fix simple compiler errors.
  • Don't attach a file unless it is absolutely necessary. If you have screen captures, don't embed the images in another file such as a Word document. Simply attach the image files themselves to your email.
  • Poor writing or emails containing badly translated text will probably go directly to my trash. If you expect me to take the time to read and reply to your message, it is incumbent upon you to take the time and make the effort to write clearly. I am not a native English speaker, but I think that what I write can be understood by people knowing the basics of English language. I expect from you the same.
  • My blog is not a tutorial for Excel/VBA. Instead, it provides you various tools and examples that can be configured together to make a working project. It is quite likely that you will need to adapt the code on the blog to your own specific requirements.

If you follow the guidelines above, you'll likely get a reply from me as soon as possible.


Can you modify a workbook/program/code snippet for me?
If I feel it will benefit other users too, then yes; I am open to making changes to anything you can find in this blog. However, if the modification you need is specific to you or your company, then I can do it, but for a fee (and not free).

Can you unlock or provide the password to a workbook or add-in you developed?
In general, NO. There is a reason why some of the files on this blog are password protected. Most of it (80%) has to do with support. I just want to prevent people from either breaking formulas, or editing the VBA code, and, then, sending me questions about why the workbook/add-in doesn’t work. The other 20% has to do with the fact that I simply don’t want to distribute my work. It’s like a typical web service (i.e. Google search); you can use it, but you are not allowed to modify it.

I understand that some people like to see “what lies beneath” of these files in order to learn how they work. However, I publish a lot of code snippets on this blog, which, hopefully, will be adequate for them to understand the logic behind those locked files. Moreover, it’s quite possible to give out source code to people who approach me politely and their intention is to use the code for non-commercial purposes. Last but not least, bear in mind that with VB6 compiled dlls or .exe files it is impossible to share source code by "unlocking" files; there is nothing to unlock.

Are you available to help me with my project?
Yes, I can do freelance work for you, as long I have free time available. For more details check this page in order to read how you can cooperate with me. Just bear in mind that my prices are quite reasonable!

Christos, I’m getting an error with my program/code. Can you help me solve it?
Sorry, I cannot help you with your error, at least for free (see the previous question). There are not enough hours in the day to help everyone and still accomplish what I want to; so I will no longer answer "how to" questions privately via email.

If you have a "how to" question, just ask it in a public forum such as Stack Overflow, MrExcel, VBA Express, MSDN or you can also try a Linkedin group, such as Microsoft Excel Users, Excel Developers or Excel and VBA Users. I am only one person, so I cannot answer all of your questions. I understand that you need help, but, posting in a forum is the best way to get it.

Minimum software requirements

What are the minimum software requirements in order to use a file or run a code snippet that I found in this blog?
Before opening any file or running any VBA code snippet that you downloaded from this blog, please make sure that your computer meets the minimum requirements that follow:

Operating system: minimum supported version: Windows XP
Sorry Linux/MAC guys, but everything that I have developed so far is based on Windows environment.

Microsoft Office: minimum supported version: 2007 (Office 12.0)
Code snippets found on this blog may work with older Office versions – such as Office 2003. However, they were originally written in Office 2010 or 2013. Note that some codes might not work on 64 bit versions of Office, especially those containing references to Windows APIs.

Autodesk AutoCAD: minimum supported version: 2010 (either 32 or 64 bit)
Keep in mind that you might need to download and install AutoCAD’s VBA module before running any sample.

Adobe Professional: minimum supported version: 9.0
Note that most of the snippets will NOT work with the free version (i.e. Adobe Reader).   

Internet Explorer: minimum supported version: 6.0
For code samples that automate Internet Explorer, you just need to have Internet Explorer on your machine. Although highly unlikely, if you don’t have Internet Explorer you will not be able to run these samples.

Personal questions

Christos, do you still teaching engineering (Thermodynamics, Fluid Mechanics etc.) or programming courses (Excel, VBA etc.)?
NO. While there was healthy interest in this service, it simply wasn’t an effective way to continue spending my time. I really enjoyed teaching, but, I cannot continue it anymore. This is the reason why a page about teaching Excel/VBA was removed from this blog.

What are you working on now?
My “engineering side” struggles to finish my Ph.D. thesis (hopefully within 2015) and also tries to enhance my HVAC skills. My “programming side” tries to learn more about C# and .NET framework in general. Moreover, web development (HTML, CSS, and JavaScript) is probably my latest interest/hobby. My recent works are usually reflected on the posts that I publish. So, if you see for example a post title like “Human Comfort & HVAC System Operation”, it simply means that I am working on HVAC systems lately.

Last update: 25 March 2015