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

Getting input object from separate VBA module

Getting input object from separate VBA module

Getting input object from separate VBA module

Hi everyone,

I have a bit of a VBA rookie question.

I am able to do long VBA programs, with single inputs, multiple inputs, loops, etc etc.

But I'd like to start cleaning up my code, and avoid doing multiple copy/paste everytime to get my code running.

So, question:

How to I call and use inputs from external macros?

For example, say I have a code that uses one axisSystem, and multiple surfaces.

How to I call an external module and use the axisSystem collected, and from another module use the collection of surfaces in a loop for example?

Thanks in advance!

RE: Getting input object from separate VBA module

Hi, i work in Visual Basic, all code is on one place.
For start you need to write some methods, i don't know do you use them.
From other side you can have one main array for ex. for axis systems, and you can use it in all of your macros.
So when you make selection it will be stored in that main array, and you can use it in every macro you want.
Ofc you can have more of those arrays for different stuff.

I have one huge Visual Basic macro app and i use this approach. I don't know structure of your code, so i don't know can you go like this.

It will be good option if you move to Visual Basic its relay cool and easy. (visual studio is free to use)

you can check this post for example https://catiavbmacro.com/2018/11/17/lego-catia-mac...

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! Already a Member? Login


Research Report - How Engineers are Using Remote Access
Remote access enables engineers to work from anywhere provided they have an internet connection. We surveyed our audience of engineers, designers and product managers to learn how they use remote access within their organizations. We wanted to know which industries have adopted remote access, which software they are using, and what features matter most. Download Now
eBook - Managing the Context of Product Complexity Using the Digital Twin
Keeping track of changes to complex products is difficult—think Aerospace & Defense equipment, new generations of commercial aircraft, and software-based automobiles. A new way to managing the digital context of the physical product is required and the answer is the Digital Twin. This ebook explores the opportunity available for Operations and Maintenance for the Digital Twin. Download Now
White Paper - Trends in Industrial Filtration
Substantial progress has been made in filtration technologies in recent years. New filter media materials, designs and processes have led to filters that are more efficient, reliable, compact and longer lasting. This white paper will discuss the various trends that are impacting operational responsibilities of MROs today and the resources that are available for staying up-to-date on the latest filtration solutions. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close