Tuesday, October 15, 2013

Installing Linux in Windows 8

As I told on this post: "The selected languages", one of my selected languages to learn how to program was Unix. However it took me a while to finally find a good Unix run-environment for my windows pc.

On the first glance, the best option would be the installation of Linux OS on a virtual box. That's why I have been trying and trying again to make the oracle virtual box work on my windows 8 but it has been in vain.
As my thirst for learning how to program in Unix is kind of out of control LOL LOL LOL, I found a better option: the Cygwin Terminal.

If you have the windows 8 and want to learn Unix I think that the installation of Cygwin is definitely a very good option. It is very fast and allows almost all the commands that Linux have. Try it!


Please check this video that I did to explain you step by step how to install it. The video has Portuguese audio but there are subtitles in English.


Thursday, October 10, 2013

How to enable the content of a workbook?(Excel-VBA)

Each time we open with VBA an excel file, coming from another person, one of the most annoying things is the fact of having to select the "enable content" option.

However, did you know that you can get rid of that security warning directly in VBA? Just write this following code,defining as true the update of the links (the argument of Open method), so for example:

















With the code above we open the file1.xls and we get rid of the update links security warning! ;) A very useful instruction in my point of view!