Excel Programming
By agihcam
@agihcam (1914)
Philippines
May 23, 2008 10:28pm CST
Did you know that you can do a lot of things in excel aside from formulas,reports and chart which we commonly used?
Excel have visual basic for application ( if you are not aware of, but if you are already knows, keep excelling ) that can automate some task for you. We normally does copy and paste process in excel, let say we need to consolidated different sheets into one master sheet, we do it manually, oh, what a tedious process isn't it?
This can be done automatically in excel, if you are new, help feature in excel is a big start.
3 people like this
4 responses
@MatejScorp13 (926)
• Croatia (Hrvatska)
24 May 08
when you know a lot of excel heres a one wuestion form me, i whant to know about this in future but when it came out now then it would be ok to hear it also now, i hope that i wont forget about it ...
im intrested in that, is excel able to be used as some kind of database file for php language, i know that it can be used for asp language, but doesnt know can it be used with php ... im intrested in something like storing your own data and then read it from it, same as the mySQL but in this case to be the excel or .xls file
3 people like this
@agihcam (1914)
• Philippines
26 May 08
Not much knowledge yet about using excel as php database since I was using mysql also for php.If it can be done with asp, then I guess it will also feasible with php. Right now what I was doing was excel application with data base interface with access database.
1 person likes this
@Dean_here (80)
• Croatia (Hrvatska)
26 May 08
Good Point.. I already know of excel capabilities with Visual Basic.
I made application for storei 6 years ago with Excel MS Office 97..
So that looks like real software.. If You want I can send you screenshots, or I can upload it here on mylot , just let me know...
@callarse1 (4783)
• United States
25 May 08
Help feature or help books regarding Microsoft Office can be helpful if you are not familiar with all the functions to use. Also there are even people who made a game out of Excel. You may play it on this website:
http://www.pixer.org/excit/
Pablo
2 people like this
