macro separate extraction base

[FIGOR71]

Hello, everyone.
I kindly wanted to ask if someone knows where it is possible to find a macro to make the extraction of the distinct base, or of a single column, of a set (from the table of solidworks) or a certain property (in a set or in a part) .
the purpose would be to extract this property or column (which would then be a description for a purchase request) in a word or excel file to get a list of things to order (a sort of distinct strangers, but without a pdm)
then we accept advice on other methods to get the same result. .
Thank you in advance and wish everyone a good Easter

 

[MassiVonWeizen]

Can't you save the distinct in excel and clean it?

 

[FIGOR71]

Can't you save the distinct in excel and clean it?

I was just looking for something automatic.. as I asked for a macro x save directly in pdf and dwg ..
Thank you.

sent by my bnd-l21 using tapatalk

 

[meccanicamg]

I was just looking for something automatic.. as I asked for a macro x save directly in pdf and dwg ..
Thank you.

sent by my bnd-l21 using tapatalk

the macro pdf dwg is there.....that of the distinct no. But you could try to do it and see if it works. It has always been said that without pdm it does not work.

 

[pose63]

I was just looking for something automatic.. as I asked for a macro x save directly in pdf and dwg ..
Thank you.

sent by my bnd-l21 using tapatalk

Hi.
save api/macro directly in xls format a distinct material (both in a drawing or in part/axieme) is possible from the 2019 version of solidworks. in previous versions it was possible to save in csv format however readable by excel.
putting together a few things quickly, the macro attached.
as a pre-condition in the open document in solidworks a separate table of materials must be selected.
if the version of solidworks is 2019 or higher saves in xls, otherwise in csv.
in the first row of the macro there is a constant that if set to true enables an opening message in excel of the newly exported file.
before the rescue is opened the window for choosing the path.
the name of the saved xls or csv file is the same as the open solidworks document.

 

[FIGOR71]

Hi.
save api/macro directly in xls format a distinct material (both in a drawing or in part/axieme) is possible from the 2019 version of solidworks. in previous versions it was possible to save in csv format however readable by excel.
putting together a few things quickly, the macro attached.
as a pre-condition in the open document in solidworks a separate table of materials must be selected.
if the version of solidworks is 2019 or higher saves in xls, otherwise in csv.
in the first row of the macro there is a constant that if set to true enables an opening message in excel of the newly exported file.
before the rescue is opened the window for choosing the path.
the name of the saved xls or csv file is the same as the open solidworks document.

Thank you 1000.. As soon as I can try and let me know. . .
I use solidworks 2020. .
Thanks again ..

sent by my bnd-l21 using tapatalk

 

[Esselle]

What's the difference between using this macro and using save by clicking the right button on the table? I still tried to use it, and I couldn't.

 

[pose63]

What's the difference between using this macro and using save by clicking the right button on the table? I still tried to use it, and I couldn't.

no difference, except a few clicks on the mouse and keyboard in less

 

[Esselle]

no difference, except a few clicks on the mouse and keyboard in less

Okay!

 

[FIGOR71]

Hi.
save api/macro directly in xls format a distinct material (both in a drawing or in part/axieme) is possible from the 2019 version of solidworks. in previous versions it was possible to save in csv format however readable by excel.
putting together a few things quickly, the macro attached.
as a pre-condition in the open document in solidworks a separate table of materials must be selected.
if the version of solidworks is 2019 or higher saves in xls, otherwise in csv.
in the first row of the macro there is a constant that if set to true enables an opening message in excel of the newly exported file.
before the rescue is opened the window for choosing the path.
the name of the saved xls or csv file is the same as the open solidworks document.

hello, unfortunately when I use the macro I return this errorsolutions on this?

Thank you.

 

[pose63]

hello, unfortunately when I use the macro I return this errorView attachment 57224solutions on this?

Thank you.

when the message comes out click on debug and post the image of the code where the macro stopped

 

[FIGOR71]

when the message comes out click on debug and post the image of the code where the macro stopped

There she is.

 

[FIGOR71]

I'm sorry, but I don't really chew the language. .
Can you be more specific?

Thank you.

 

[pose63]

View attachment 57225There she is.

devi lanciare the macro with the sub main()

 

[pose63]

I'm sorry, but I don't really chew the language. .
Can you be more specific?

Thank you.

if you associate the macro to a button in the macro bar you have to set it so

 

[pose63]

I'm sorry, but I don't really chew the language. .
Can you be more specific?

Thank you.

I attach the updated version where I eliminated the routine that could create ambiguity in startup

 

[FIGOR71]

I attach the updated version where I eliminated the routine that could create ambiguity in startup

Hi. I tried the macro and now it works.
the difference between table save and macro are the previews of the files that are created.. I just noticed that the preview does not match the description line... is there solution?
also useful the choice of the directory where to save the table

Thank you

 

[Esselle]

Good morning, I'm here now:

 

[pose63]

Good morning, I'm here now:
View attachment 57246

can you find the filename with extension?

 

[Esselle]

No, there's no extension.