If you are a teacher or a professor, you probably have several students in your class. Let’s say you would like to provide them with an update on their averages after every single quiz and exam they take. But you hate to email each and everyone of them because it consumes a lot of time to copy data from your Excel file of student records to individual emails. This is where the extract data from row by row using loop iteration comes to save you.
Category Archives: Computer Science
Computer Science (CS) and Information Technology (IT) related items will be posted under this category. Topics include, but not limited to, system administration, hardware/software troubleshooting, coding/programming (PHP, HTML, Java, Python, etc) and more.
Visual Basic Script using the Interface
This is the second article a ongoing series of VB scripting guide. If you are unfamiliar with programming in Microsoft Excel, don’t be afraid, start your journey into VisualBasic with basics of VB explained here.
Macro recorder is great for those who are new to the coding in general. A user can utilize the graphical front end of Excel to generate Modules, which can be modified using conventional VBA Editor.
Excel Visual Basic Scripts
A simple program like Microsoft Excel 2010 can be used as a powerful tool by manipulating the software. Microsoft has published several “how to” guides such as this one Getting Started with VBA in Excel 2010. They are very good articles, and I am not trying to beat them. After all, they wrote the software anyway. I just want to introduce Excel as a powerful programing tool for home users Continue reading Excel Visual Basic Scripts
Elementary guide to Remote Desktop
I remember when I was a kid; I was having an uphill battle with my Windows machine because the RDC (Remote Desktop Connection) only worked within the internal network. At that time I failed to realized that specific port(s) has (have) to be opened from the LAN (Local Area Network) Continue reading Elementary guide to Remote Desktop
CSS default and custom elements
When using CSS (Cascading Style Sheets) there are two main types of elements; the default elements associated with conventional HTML tags and the custom elements created by the developer to produce desired effects. The custom elements are more useful than the default since Continue reading CSS default and custom elements