Hi,
Excel and VBA is amazing. I just want to learn quickly that what else can by done by excel.
I can send emails,
I can create folders,
I can download webpages,
It seems that excel and VBA offer a great oppurtunity for many things that we use in our daily office work.
Im sorry if my question is foolish but I wanted to expand my horizon.
Do a web search for "Free VBA tutorials" and you will find several You Tube videos to help you along. If you have the finances, you can also find some pretty good books at a prominant book store or an online site like Amazon for VBA programming. I believe John Walkenbach updated his book in 2013 and it is pretty good for beginners. You can also learn a lot by reading the posts on this site and trying some of the techniques on your own system.Originally Posted by 1tane1
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thank you very much. I learnt a lot from this forum and there are interesting topics that one may develop himself/herself
Back in the day, we had a new satellite internet technology that regularly experienced uplink failures. There was nothing produced by the system that alerted us to this, it was only when the customers began calling in that we knew there was an issue.
The way of determining if there was actually a failure was to login to the system and run a command, the output of which identified the failed uplink.
I created a spreadsheet that logged in to the system every minute, ran the commands to check if there was an uplink issue, and if there was, identified the uplink and alerted the staff with an audible alarm. The uplink was able to be fixed before customers were aware of the problem. The results from the data collected every minute were also used to plot a daily chart of the equipment utilisation which was saved each day.
I'm sure there are more complicated things that can be done, but this gives you an idea that not all spreadsheets are there to just crunch a bunch of numbers.
Wow that was a nice way of usage.
I got the idea, thank you very much.
The question generally isnt "Can I do it in VBA?" but "Should I do it using VBA?"
In other words it can do alot, both in the Office Program and outside of it. However, often one needs to decide if they should do something using VBA.
For example, I can write code that will fill the currently selected cell yellow. Should I make code to do this? Probably not, there is a built in button that does this already.
VBA at its core is meant to do 1 of 2 things.
- Something I cant do manually
- Something that would be teadious to do manually
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks