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 ask you to save the file to the hard disk of your computer.

I clicked the icon, but I cannot download the file?
Please retry one or two more times. Sometimes Google 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 requested file.

I tried to use a file that I downloaded from your 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 error is a top priority for me. In general, I strive 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.

Email policy

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 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 lie 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 in your message. Don't throw me 100 lines of code and say "It doesn't work." Narrow things down to perhaps ten lines of code that illustrate the problem. Tell me exactly what the problem is; does the code blow up? Compiler error? Runtime 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. Just attach the picture files themselves to your email.
  • Poor writing or emails containing poorly 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 an 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 do a working project. It is quite likely that you will need to adapt the code 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 on this blog. However, if the modification you need is unique 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 just 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 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 the source code to people who approach me politely, and they intend to use the code for non-commercial purposes. Last but not least, bear in mind that with VB 6.0 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 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 to use a file or run a code snippet that I found on 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 initially 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 a healthy interest in this service, it just wasn’t an efficient way to continue spending my time. I really enjoyed teaching, but, I can not keep 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 in the posts that I publish. So, if you see for example a post title like “Human Comfort & HVAC System Operation,” it just means that I am working on HVAC systems lately.

Last update: 25 March 2015