Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dynatang

  1. dynatang

    VBA store arrays in public function and use it repeatedly?

    johnwm, It's really working. You are right. The variables I declared work till I close the workbbok. Thanks A million.
  2. dynatang

    VBA store arrays in public function and use it repeatedly?

    I will try and let you know the result. thanks anyway.
  3. dynatang

    VBA store arrays in public function and use it repeatedly?

    Thanks. But even static variable does not work.
  4. dynatang

    how to run autocad using exe file?

    So far as I know, is use VB only.
  5. dynatang

    VBA store arrays in public function and use it repeatedly?

    I coded the clustering algorithem into a excel public function. Then VBA solver is used to adjust two parameters to reach the target. Because most time is used in inputing a same large data file, I am wondering is there any way in VBA to read in data once into memory and use by rest of the...

Part and Inventory Search