×
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

Macro deployment

Macro deployment

Macro deployment

(OP)
Hi:

Im trying to deploy some catvba macros (with userforms) with a catalog according to Mike Berry's deployment instructions. By this moment I've tried every workaround possible without success. The best result so far is when the catscript is opened with the catalog, then the attached error appears, click ok, and the macros window opens allowing to select the catvba macro. Is there someone here that can call a catvba macro with a catalog without errors.

The macros and catalog are placed in a server that every user can access. When I open the catalog and call the macro there's no problem, the problem comes when any other user try to do it.

Any help is welcome and appreciated.

RE: Macro deployment

(OP)
I already tried that with no result. Can you explain how to do it?, perhaps Im doing something wrong.

RE: Macro deployment

(OP)
well, the macros are in a server where the users can access any file. What do you mean by "same kind of installation"? if you mean the same catia versio, yes, everyone has V5R18.

RE: Macro deployment

What Ferdo wanted to know is if all user have access to this location from the E:\ drive.

Looks like something is not define properly in Line 29... Can you share some part of the code?

Eric N.
indocti discant et ament meminisse periti

RE: Macro deployment

(OP)
Here is the whole code to invoke a CATVBA with a Catscript:

CODE -->

Sub CATMain()

 

Dim param()

Dim oFilePath As String
Dim oFileName as String
Dim oModule as String

Dim oSystemService As Variant

Set oSystemService = CATIA.SystemService

 

oFilePath = "E:\USERS\marco12\Catalogo\" 'path where catvba project is stored

oFileName = "Tube_creation_V1.1_AW.catvba" 'name of catvba project

oModule = "Launcher" 'name of the module

 

Dim ss As Variant

Set ss = CATIA.SystemService

ss.ExecuteScript oFilePath & oFileName, catScriptLibraryTypeVBAProject, oModule, "CATMain", param

 

End Sub 

Also, I dont know if having all the code in the form has something to do with the error (all the code is within the form instead of in individual modules).

Thanks again for your excellent support!!!

RE: Macro deployment

What OS you have installed?
If you are using Win7 with 64bit, catvba won't work.
Ask your IT to install Catia with 32bit.
Regards,
Sundeep

RE: Macro deployment

(OP)
Hi sundeep198

I dont know if you're refering to the fact that the deployment doesnt work because Im programming in Windows 7 64 bit and then copying the code in Windows vista is working perfect.

RE: Macro deployment

Your code to invoke catvba is correct, the problem is how the users has configured their paths to catalog location.

In my case, I saw users which had defined in same way like me the path to a certain location/server and for others in a different way (for example they don't have E drive...).

This depends on how your IT guys did the network connections. I saw also some other cases when they didn't install vba at all...or registration for CATScript and catvbs was done by default to DELMIA and not CATIA...

Regards
Fernando

https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...

RE: Macro deployment

(OP)
So... there's no way to solve this problem without involving the IT guys?

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