CATIA V5R17 doesn't write apropriate design table on xls
CATIA V5R17 doesn't write apropriate design table on xls
(OP)
Hi All
I am trying to create some parameters and write them on an excell file , CATIA creates the xls file , but excell can not read it , mentions it's another format , but when I open it , the file is empty , what's the problem ? office is 2010 btw
thank you very much
I am trying to create some parameters and write them on an excell file , CATIA creates the xls file , but excell can not read it , mentions it's another format , but when I open it , the file is empty , what's the problem ? office is 2010 btw
thank you very much





RE: CATIA V5R17 doesn't write apropriate design table on xls
What are you using? Macros? In which language? More details...
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
I've done in the past an Excel file which is communicating with CATIA (and back) but I have to remember where I post it
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
this is very much helpful , but I need to know , how to make this ... and how automatic it can be
RE: CATIA V5R17 doesn't write apropriate design table on xls
By pressing the buttons you run the macros inside Excel file.
The excel vba is not protected, so you can take a look also in the code. I will try to find also that tutorial later.
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
What SP have you applied against Office?
RE: CATIA V5R17 doesn't write apropriate design table on xls
@fernando : thank you , still I will need help , well the Macro is in VB , just can I ask , this part is what you have written or it's made by excell while creating the cat file ? thanks a lot , I think I should wait to see if the tutorial could be found , thank you so much for you kind help and attention Fernando , it's a big help and big part of my work
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
There are possibilities to create automatically the parametric part with formulas, relations a.s.o. , eventually based on a predefined design table, I've done also an example in the past.
I hope this evening (in Bucharest is morning now) I will have time to find all of them.
To access Tools-References you need to stop debugging (this is the most common problem, trying to access when code is running and forget to stop running the code).
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
Check the Dassault Knowledgebase; but, I do not think they have a solution for it since they do not support releases that old.
They only support releases that are at most two release levels old.
RE: CATIA V5R17 doesn't write apropriate design table on xls
I would suggest to read first in help docs about design tables and parameters.
You have here solid7 tutorial, pity he is not so active now in the forum, you could learn a lot from him (as from many others here).
Now, copy this design table in C:\Temp folder , open an empty CATPart and run this macro (to create a prism, is a recorded macro, just for example).
With the prism created, you can run now macro to play with design tables configurations (by modifying the configuration you can modify dimensions also).
All macros are hard coded, just for exemplification, so you have to respect what is written inside
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
The macro in Excel can have problems because of Office version, for me is still working fine (CATIA v5r21 , Office 2003).
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
Just wanted to know , that the first excell file that you uploaded , you have written the macros independently from CATIA ? the file that has modifying buttons
RE: CATIA V5R17 doesn't write apropriate design table on xls
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
I want to know also , if it's possible to write the Macro in excell that can save the edited file in CATIA as a step format
RE: CATIA V5R17 doesn't write apropriate design table on xls
I have encountered a very simple problem , I have opened a Macro runtime window , and put this line in it
Language ="VBScript"
Sub CATMain()
Dim Document0 As Document
and I get an error of expected end of statement
while it is exactly as it's written in the help and everywhere
what is the problem ?
RE: CATIA V5R17 doesn't write apropriate design table on xls
Example:
CODE --> CATScript
Language="VBSCRIPT" Sub CATMain() Dim partDocument1 As Document Set partDocument1 = CATIA.ActiveDocument Dim product1 As CATBaseDispatch Set product1 = partDocument1.GetItem("PART1") 'the Part Number of the part is "PART1" product1.DescriptionRef = "TEST DESCRIPTION 2" End SubRE: CATIA V5R17 doesn't write apropriate design table on xls
@Fernando : on the prism code there is the same problem , but also a bit more , that when I run it as VBscript the expected end of statement appears , and when I run it as CATScript , the line activedocument is not accepted as a right argument , so I don't know which is which and how to correct it
RE: CATIA V5R17 doesn't write apropriate design table on xls
Macro prism will run correctly if you open first an empty part, if your active document is nothing or something else then CATPart, macro will give you that error.
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: CATIA V5R17 doesn't write apropriate design table on xls
even I get the "expected end of statement " error for this simple script when also I open the part :
Sub CATMain()
Dim strHello As String
strHello="Hello"
MsgBox strHello
End Sub
sorry for many questions , but I am studying the books but in CATIA can't take even the first step
RE: CATIA V5R17 doesn't write apropriate design table on xls
RE: CATIA V5R17 doesn't write apropriate design table on xls
Then compare the code.
Personally, I prefer VB.NET.
Its easy to work with and much more powerful that a scripting language.
But, I see this thread is deviating well far away from where it started; so, I'll leave it at that.
RE: CATIA V5R17 doesn't write apropriate design table on xls
No one can help you if you don't provide pictures or tell what are you using very clear -vba in CATIA or Excel, CATSCript, catvbs or what ever....
For example, your last code is working fine for me in CATScript, CATIA v5r21, doesn't mater if I have something opened or not in CATIA.
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...