Ironworks Gaming Forum - View Single Post

pritchke · 02-10-2004, 10:42 AM

Looks like you got your answer. VBA is great, many of companies still use excel so knowing VBA can be very helpful.

One of my problems was I had a ton of data for retail locations. They were divided into sheets by provinces and states. This data is updated often and needs to go up to the web by province and state. I created a little VBA program to loop through each sheet when it is updated obtaining all the data and turning it in to a JavaScript array to be used by the web. Before I got the problem they were retyping all the data all the time, which is insanity.

I had to do some JavaScript to access the data when someone clicks a link. But that is extra and if you wanted you could have just turned the data straight from excel into formatted HTML pages using VBA. Just imagine cutting the time of a task from days to seconds.

Anyway this is a practical application of VBA. Good luck!!!!!

[ 02-10-2004, 10:47 AM: Message edited by: pritchke ]

02-10-2004, 10:42 AM	#5
pritchke Bastet - Egyptian Cat Goddess Join Date: September 5, 2001 Location: Calgary, AB Age: 50 Posts: 3,491	Looks like you got your answer. VBA is great, many of companies still use excel so knowing VBA can be very helpful. One of my problems was I had a ton of data for retail locations. They were divided into sheets by provinces and states. This data is updated often and needs to go up to the web by province and state. I created a little VBA program to loop through each sheet when it is updated obtaining all the data and turning it in to a JavaScript array to be used by the web. Before I got the problem they were retyping all the data all the time, which is insanity. I had to do some JavaScript to access the data when someone clicks a link. But that is extra and if you wanted you could have just turned the data straight from excel into formatted HTML pages using VBA. Just imagine cutting the time of a task from days to seconds. Anyway this is a practical application of VBA. Good luck!!!!! [ 02-10-2004, 10:47 AM: Message edited by: pritchke ]