×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Gentlemen, I am new to Excel VBA a

Gentlemen, I am new to Excel VBA a

Gentlemen, I am new to Excel VBA a

(OP)
Gentlemen,
I am new to Excel VBA and have got to the stage when I write my own function procedures and make available to all my spreadsheets as addins. I have about 40 engineering functions/addins and the number is growing.

I am now wandering if there is any advantage in compiling the VBA functions or addins in terms of increasing speed.

If there is, is there a good book that would tell me how to proceed.

Regards,
athomas236

RE: Gentlemen, I am new to Excel VBA a

I don't really think that speed will be a major factor in either path you choose. It really only affects how you want to distribute the functions. If it's all in-house, you can simply add the module to personal.xls for each system. But, if you go this route, you may want to add a digital signature to avoid the constant macro virus warnings. For in-house projects, you can sign your own programs. See the following MSDN article for more info.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsigningvbaproject.asp

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Gentlemen, I am new to Excel VBA a

(OP)
dsi,
Thanks for advice.
athomas236

RE: Gentlemen, I am new to Excel VBA a

Try one of John Walkenbach's books http://www.j-walk.com/ss/.  I use his book Excel 2000 Power Programming With VBA constantly.  If you are new to Excel/VBA, you will find his books extremely useful anyway.    

My experience is that VBA codes can be sped up a lot.  I would also suggest you use the timer function to see where your time consuming subroutines are.

RE: Gentlemen, I am new to Excel VBA a

(OP)
Thanks morrow

athomas236

RE: Gentlemen, I am new to Excel VBA a

I have moved chunk of my VBA code to ActiveX DLL before and did a comparison of the speed. Surprisingly the executing speed of the two are almost the same. To my own understanding, VBA code cannot be compiled. The way to speed it up is code optimization in the Loop, With block etc.

dongxiao PE
http://www.cadtool.net

RE: Gentlemen, I am new to Excel VBA a

(OP)
Thanks dongxiao PE

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources