come comunicae tra excel e solidworks

[SolidUser]

the attached example shows how to communicate between excel and sw.
This is a simple example, which illustrates how to connect to an active excel session and insert the components listed in the excel sheet into an axieme document.

prerequisites:
1) active unit
2) Open excel (the text in cells must really point to files)

What can it serve?
I must create a set from a distinct of a management.
it is exported from the management in txt or in excel and it is used to create the assemblies.

 

[re_solidworks]

domandina: Does it also work on the network? because in this there is a pharaoh curse of reggio and his staff....:biggrin:

 

[SolidUser]

Yes, it also works on the net.
the macro does nothing but read the contents of the cells and the rest are opening / inserting operations together.
the macro is only a small example of how you can interface solidworks with excel.
the implementation according to the user's needs are at the expense of the same.

 

[reggio]

...già...

f a r a o n i c a m a l e d i z i o n e

What can it serve?

finally creating machines p a r a m e t r i c a m e n t e :d
practically the reason that pushed us towards the 3d

and until 10 I can't prove it.

insert the components listed in the excel sheet into an axieme document.

pppfffff ie additure can do "if the power is 2,2kw insert motor2_2kw.part" and "if the power is 3kw insert motor3kw.part"? ? ?

it is exported from the management in txt or in excel and it is used to create the assemblies.

But... but... but... just import or connect the excel sheet directly?

 

[SolidUser]

.........

I think you don't understand what the macro does.

 

[reggio]

I think you don't understand what the macro does.

Hi, no, I didn't understand before.
Now I have seen, the example shows what you can do by knowing vbasic:finger:
(I don't know...:frown
ot: I just responded to your post "faster bug resolution" where I mentioned to an old as important problem with excel/swx, since you know the topic, I asked if you could take a look at it and give me your opinion, this is the linkexcel2007 to command assemblies and parts: from c:\ yes, on net no... (? ? )