I have this macro in CATIA to export tables from CATIA to excel based on certain table names. Im having problem with it since it only runs properly if I have an excel open before running it. If i dont have an excel opened it says that the file has been saved but in reality no file has been saved...
Hi everyone hopefully soneone can correct my code to find number of count of specified text in catia drafting and then replace exact matches only with what i want. Current condition is when i try to replace 1-1 with lets say 2-1, it also replaces the 201-1 with 202-1 since it also has a 1-1 in...
I followed your advice to check for previous char and skip it if it's a "-" since i can't get the correct regex that works like that. Thank you! :)
Considering that ballons in figures are considered as text, and my balloons have those patterns like (1-1), is there a way to exlude the text in...
The only problem i have now is it also detects the pattern even it is not standalone. Example it add ellipse on "1001" in "123226-1001". My pattern so far is x-y where x is 1-4 digits, y is 1-2 digits, and numbers from 1000-1999.
Here's my current code:
Sub CATMain()
' Set the CATIA popup...
Thank you everyone for the help. But i cant get it to work. It still detect the other words aside from my pattern. Is it possible that it is because my pattern varies in length?
Example I have an instruction like:
1. Remove the sealant 101-1 from the head of screws 1-1. Clean using alcohol...
It made the whole text frame to change into ellipse. The outcome i was hoping to have is the macro will detect all the number with patterns like 123-45 then change the properties of those detected number to have an ellipse border/frame.
I'm stuck on this one:
Sub CATMain()
' Set the CATIA popup file alerts to False
' It prevents the macro from stopping at each alert during its execution
CATIA.DisplayFileAlerts = False
Set oDrwDocument = CATIA.ActiveDocument
Dim TextFound As Boolean
TextFound = False...
Help me with this one please. It also add ellipse to the word on its right. For example the sentence is "remove screw 101-1 from the panel" it add ellipse on "101-1 from the pan". It looks like this "remove screw (101-1 from the pan)el.
User
Sub CATMain()
' Set the CATIA popup file alerts...
Hi thank you for the response. Actually I've been looking around in the forums but i couldn't see something similar to what i want. Unfortunately I'm not really familiar with macros and only been using chat gpt to try and have the code for what i need. But unfortunately im stuck and always get...
Hi everyone. I was just wondering if someone can help me with a macro that would greatly help me with my projects. In CATIA V5 drawing, I insert text to list my instructioms. These instructions have item number on it so that the reader can refer to the Bill of materials when reading it. For...
