Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Way to extract custom properties out of a SW file via VBA?

588 views
Skip to first unread message

Marcel Büchi

unread,
Jun 14, 2005, 4:37:47 AM6/14/05
to
Hi

Is there a way to extract the custom porperties out of a SW file using VBA?
Similar to what the Explorer can do when right-clicking a SW file, 3rd tab.


Thank you
Marcel Büchi

TOP

unread,
Jun 14, 2005, 9:04:15 AM6/14/05
to
Download SWIT and see for yourself.

I believe this is also documented in the API help and on the SW API
support pages.

Marcel Büchi

unread,
Jun 14, 2005, 10:53:01 AM6/14/05
to

"TOP" <kell...@cbd.net> schrieb im Newsbeitrag
news:1118754255....@o13g2000cwo.googlegroups.com...

> Download SWIT and see for yourself.
>
> I believe this is also documented in the API help and on the SW API
> support pages.
>

I was looking for a way to get the custom properties without having to use
SW.
I can extract properties from files when loaded into SW by using MS Access
and and VBA to store the information in a table.
But that's not what I want.
I'd like to process somewheres around 20000 SW files and saving the custom
props in an Access table.
Similar to the VBA Function GetAttr(Path of file)

I'd be nice to have a function like: GetCustomProperties(Path of file)

Marcel

That70sTick

unread,
Jun 14, 2005, 11:35:08 AM6/14/05
to
There is an object called "DSOfile" (see Microsoft's website) that can
be added to VB projects. This object will enable you to access custom
properties without opening files in SW.

GreenHex

unread,
Jun 14, 2005, 1:34:08 PM6/14/05
to

DSOFILE... (google that one!)

That would enable one to quickly view/ extract Document
Custom Properties without opening the SW document in
SolidWorks, but not Configuration Specific Custom
Properties which is the one that is very much in
demand!

Regards,

Vinodh Kumar M.
www.swCP3.com

TOP

unread,
Jun 14, 2005, 2:16:45 PM6/14/05
to
The problem is that there are configuration specific and document
custom properties. The former requires SW and the later can be done
without opening SW. There have been detailed discussions on this group
regarding this subject. You might do a search.

Marcel Büchi

unread,
Jun 14, 2005, 3:17:19 PM6/14/05
to
Thanks to all
Dsofile worked perfect. I got now an Access table with the drawing numbers
and for each the custom properties!
Thanks
Marcel

"GreenHex" <Gree...@gmail.com> schrieb im Newsbeitrag
news:1118770448.3...@o13g2000cwo.googlegroups.com...

agnald...@gmail.com

unread,
Jun 15, 2005, 6:57:03 AM6/15/05
to
I think that everything you need you can get from Solidsentry.
www.proxicad.com

SW Monkey

unread,
Jun 15, 2005, 9:05:39 AM6/15/05
to
I downloaded SWIT, and couldnt figure out why it wont show my existing
custom propertys. I put my custom properties in the "Custom" tab, not
the "Configuration Specific" tab. We dont use configurations very much
here, if any, but are their any advantages to using the "Configuration
Specific" tab just for the Default config?

Is there a way to get SWIT to look at the Custom Tab?

Markku Lehtola

unread,
Jun 15, 2005, 12:03:05 PM6/15/05
to

No, it's using only conf.specific stuff. Custom tab is for losers that
don't know how to use configurations ;-)

--
regards
Markku

www.markkulehtola.net

SW Monkey

unread,
Jun 15, 2005, 4:37:04 PM6/15/05
to
Markku, wtf? hehe

Im sure our company can use configurations on some of our parts, but
the majority would never need them.

Is there a way to get SWIT to look at that other tab?

Marcel Büchi

unread,
Jun 16, 2005, 3:48:24 AM6/16/05
to
Hi ProxiCAD
Is this nifty tool available in German language?

<agnald...@gmail.com> schrieb im Newsbeitrag
news:1118833023.7...@g44g2000cwa.googlegroups.com...

Markku Lehtola

unread,
Jun 16, 2005, 5:33:46 AM6/16/05
to
On 2005-06-15, SW Monkey <google311.50...@spamgourmet.com> wrote:
> Markku, wtf? hehe
>
> Im sure our company can use configurations on some of our parts, but
> the majority would never need them.

You can still save the information by using configuration specific
data...at the end there is no difference; you create drawing and BOM, data
is read from the model...There is always that "Default" configuration you
know...:-)

I think it's better to handle it this way because you don't usually know
if there is going to be configs or not in the future...and if that happens
you don't have to play with the properties (move them from custom side to
config side...)


>
> Is there a way to get SWIT to look at that other tab?
>

I don't have any plans for that...there is a free tool for that already
(it's not using configurations at all thought). There are also tools to
move the props from custom side to config side I guess.

But...I understood that your problem is existing models, so I feel your
pain. Maybe SWit 3 will have this option (if there ever will be next
version).

--
regards
Markku

www.markkulehtola.net

CS

unread,
Jun 16, 2005, 9:42:07 AM6/16/05
to
All you have to do is pass an empty string to
ModelDoc2.GetCustomProperty("","Property Name) this will get non
config specific properties. Or you can use the DSOLE file .exe as
mentioned above it can only get non config specific properties.

Corey

SW Monkey

unread,
Jun 16, 2005, 1:45:24 PM6/16/05
to
Markku, what free tool is that?

Markku Lehtola

unread,
Jun 16, 2005, 3:52:15 PM6/16/05
to
On 2005-06-16, SW Monkey <google311.50...@spamgourmet.com> wrote:
> Markku, what free tool is that?
>

Google, my man, google...:-)

http://www.trimech.com/solutions/techsprt-free-utilities.htm

Markku

> "I don't have any plans for that...there is a free tool for that
> already
> (it's not using configurations at all thought). "
>


--
regards
Markku

www.markkulehtola.net

GreenHex

unread,
Jun 16, 2005, 9:56:01 PM6/16/05
to

If you *are* in the mood for trying out different CP editors,
you could try the free "swCP3" or maybe "swProp2"
available at www.swCP3.com.

With regards,

Vinodh Kumar M.
www.swCP3.com

TOP

unread,
Jun 17, 2005, 7:09:22 PM6/17/05
to
Pretty cool. I played with it a bit today. This thing seems to have
some depth to it.

avif

unread,
Feb 1, 2014, 6:10:02 AM2/1/14
to
Hi , All

I'm looking for way to extract custom properties from mt Solidworks parts to excel.
I'll appricate to get a ready utility for that

Regards

Avi


0 new messages