Open Script Solution

Yesterday I faced a situation while I was trying to get some sub-string values that derived from a single string that being saved in database, and displayed them to the checked CheckBoxes control in PHP. Let’s say I had 5 CheckBoxes control named Applications on my form, whereas the values stored in a single string from database, for instance, is: “Application 1, Application 3, Application 5″. Then I wanted that the first, the third, and the fifth CheckBoxes would be checked based on that string. So, finally, I wrote this following code to solve my problem. Read more…

You can read and retrieve data from Microsoft Excel Worksheet easily by using your application that you made by Visual Basic 6 (VB6) programming. Simply just using its Microsoft Excel Object Library reference provided by VB6. The following code will show you how we can do that step by step. Started from how we can prepare the Excel object, get or create the Excel object, opening the Excel file, opening the Excel worksheet, accessing (read and displaying) the data from Excel file, closing the Excel worksheet, closing the Excel file, until cleaning-up the memory used by the Excel object. This is very very important for you, since almost our data stored in Microsoft Excel file, and not always in the database. Read more…