Free Softwares to help you learn Regular Expression
Even some folks said that you will get better when you get used to Regular Expression, it is still a complex subject to explore and to master. But if you can’t hide from it, especially when you need to deal with .htaccess, mod_rewrite or a complex string parser, here is the list of tools you can use to start learning regular expression. Please note: I said they are free here...
Microsoft Excel Import External Data Problem: When Microsoft Query doesn’t recognize some of your parameters
This is a summary pulled from a discussion on IT-Toolbox with Alejandro Rodriguez titled “Excel query doesn’t allow me create 3rd paremeter for a criteria”. He said there he was having a problem with Microsoft Excel Import External Data feature. He posted on the forum that Microsoft Query is not recognizing one of his query parameters. I got curious about it and...
Storing your Excel Application Settings in the registry with GetSetting and SaveSetting Method via macro code
When you deal with VBA Application such as Excel Application, there will be a chance when you need to preserve some settings related to your application. The most common places where most programs store the application settings will be in a database, .ini file or the windows registry. A password protected database will be the ideal choice, but I am not going to talk about that today....
What's New Here?Subscribe to RSS feed
Free Softwares to help you learn Regular Expression
Even some folks said that you will get better when you get used to Regular Expression, it is still a complex subject to explore and to master. But if you…
Microsoft Excel Import External Data Problem: When Microsoft Query doesn’t recognize some of your parameters
This is a summary pulled from a discussion on IT-Toolbox with Alejandro Rodriguez titled “Excel query doesn’t allow me create 3rd paremeter for a criteria”. He said there he was…
Storing your Excel Application Settings in the registry with GetSetting and SaveSetting Method via macro code
When you deal with VBA Application such as Excel Application, there will be a chance when you need to preserve some settings related to your application. The most common places…
