The stuff I write for work in EXCEL·XP (VBA) out performs the main frame and I have to write loops to burn time. So these things will be most helpful. Also with Excel there is virtually unlimited memory available and more references that I will probably ever read through.
My biggest macro is several thousand lines and it take less then 7 seconds per loop. That includes collecting data, filling out reports, doing necessary calculations and filling in data as well as repeating virtually every step to 50 times. (If it goes faster then that the host won't keep up.)
By the way, does VBA hook up the same way as you listed for VB? There are subtle differences and being sure is never a bad thing.
"By the way, does VBA hook up the same way as you listed for VB? There are subtle differences and being sure is never a bad thing."
Not sure... most of the peculiarities of setting up the spread sheet from VB4 were dependant on how Excel wanted to see things.
Once you define an object in VB4, the name·acts as an alias to the function you want to perform.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔ Beau Schwabe
IC Layout Engineer
Parallax, Inc.
Post Edited (Beau Schwabe (Parallax)) : 11/3/2006 4:21:54 AM GMT
kind of a sorta related note. If you take a class at a school that is a member of the Microsoft Developer Network Academic Alliance (MSDNAA), you can get pretty much any MS software package for free (or a minimal charge).
I only know this because I work for one. Students here can get anything from MS except for Office. We host mot dev tools so they can download for free (visual studio, msdn library, project, visio etc) If students want to buy CDs from MS, they are charged something like $12 for Visual Studio.
I do lots of programming in VB and quite a bit in VBA (tried to teach a VBA class at local community college, but nobody signed up ;-(
feel free to PM me if you have questions, I have lots and lots of VB and VBA reference material and I've done lots of projects (database driven powerpoints and spreadsheets, generating them on the fly, real-time so to speak)
I was going to make a sort of generic interface because of all of the requests for PC apps to control boe-bots.. just haven't had the time.. but now that house projects are winding down ...
anyway most of the differences between VB and VBA are in declarations and subs etc. using controls should be almost exactly the same. I have VB6 installed as I liked it the best of the bunch. let me know if you want to test some things, happy to ship you some code/projects
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
stand back! I have a slide rule and I know how to use it!
Comments
Thanks.
The stuff I write for work in EXCEL·XP (VBA) out performs the main frame and I have to write loops to burn time. So these things will be most helpful. Also with Excel there is virtually unlimited memory available and more references that I will probably ever read through.
My biggest macro is several thousand lines and it take less then 7 seconds per loop. That includes collecting data, filling out reports, doing necessary calculations and filling in data as well as repeating virtually every step to 50 times. (If it goes faster then that the host won't keep up.)
By the way, does VBA hook up the same way as you listed for VB? There are subtle differences and being sure is never a bad thing.
Post Edited (AIman) : 11/3/2006 3:07:07 AM GMT
"By the way, does VBA hook up the same way as you listed for VB? There are subtle differences and being sure is never a bad thing."
Not sure... most of the peculiarities of setting up the spread sheet from VB4 were dependant on how Excel wanted to see things.
Once you define an object in VB4, the name·acts as an alias to the function you want to perform.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Beau Schwabe
IC Layout Engineer
Parallax, Inc.
Post Edited (Beau Schwabe (Parallax)) : 11/3/2006 4:21:54 AM GMT
Check this out
I have found this page very useful, you might want to take a look...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrgrfexcelapplicationobject.asp
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Beau Schwabe
IC Layout Engineer
Parallax, Inc.
I only know this because I work for one. Students here can get anything from MS except for Office. We host mot dev tools so they can download for free (visual studio, msdn library, project, visio etc) If students want to buy CDs from MS, they are charged something like $12 for Visual Studio.
I do lots of programming in VB and quite a bit in VBA (tried to teach a VBA class at local community college, but nobody signed up ;-(
feel free to PM me if you have questions, I have lots and lots of VB and VBA reference material and I've done lots of projects (database driven powerpoints and spreadsheets, generating them on the fly, real-time so to speak)
I was going to make a sort of generic interface because of all of the requests for PC apps to control boe-bots.. just haven't had the time.. but now that house projects are winding down ...
anyway most of the differences between VB and VBA are in declarations and subs etc. using controls should be almost exactly the same. I have VB6 installed as I liked it the best of the bunch. let me know if you want to test some things, happy to ship you some code/projects
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
stand back! I have a slide rule and I know how to use it!