ssc456
Fully Optimized
- Messages
- 4,280
Hey Guys and Dolls,
I return once again after a period of absence to grace you with my presence, share my knowledge and just have a good old chit chat.
My first subject being Microsoft Excel. . . . . . . WOW what a program.
First off i start by asking a question, in your opinion what d you think Excel can do as a program. If your answer is something along the lines of takes various tables of data, add them, average them report on them then your in for an eye opener.
My answer would be "just about anything".
alot of you may know this but i'm betting many don't Excel has a built in VB editor which in a sense means you can write your own programs within excel to do just about anything. I won't go into too much detail but i now have Excel interacting with the software i user at work, pulling data live from the database reporting on it and accepting user responses and in turn writing to the database.
What a tool!! I reccomend anybody that works with spreadsheets regulary to google around and research what you can do with excel VBA as you can probably make your working life ALOT simpler.
I return once again after a period of absence to grace you with my presence, share my knowledge and just have a good old chit chat.
My first subject being Microsoft Excel. . . . . . . WOW what a program.
First off i start by asking a question, in your opinion what d you think Excel can do as a program. If your answer is something along the lines of takes various tables of data, add them, average them report on them then your in for an eye opener.
My answer would be "just about anything".
alot of you may know this but i'm betting many don't Excel has a built in VB editor which in a sense means you can write your own programs within excel to do just about anything. I won't go into too much detail but i now have Excel interacting with the software i user at work, pulling data live from the database reporting on it and accepting user responses and in turn writing to the database.
What a tool!! I reccomend anybody that works with spreadsheets regulary to google around and research what you can do with excel VBA as you can probably make your working life ALOT simpler.