Can I use the Excel Visual Basic Macro for run vb code like a classic exe macro? (for example written with visual studio)
I think that with Excel I only change Variables, or not?
For example: Can I draw a View of a 3D model in a dft file, using an Excel VB macro?
Yes, As @JB has mentioned this is possible.
Everything that you can possibly do from Visual Studio standalone EXE can be done from Excel VBA also.
The lanuage to be used is old-fashioned VB but it is powerful as well for moderate purposes.
Personally I have a liking for using Excel for some types of Solid Edge automation tasks typically which take tabular data as input. These can be formatted nicely and also sorted, etc.
[ Everything under the sun about - Solid Edge ]
here is a small example:
Dim objApp As Object Dim oDoc As SolidEdgePart.PartDocument Set objApp = GetObject(, "SolidEdge.application") Set oDoc = objApp.ActiveDocument
there is a wonderful example available directly witihn the customs folder of Solid Edge
Take a look into the "bearing"
This shows the connection from an Excel table to a Solid Edge Part
oVars is the variable for the variables collection.
"ShaftDiameter" is the variable name in the variable table.
the other argument is the formula with complete path name with value in Row no. 11 and column G i.e. column number 7
Refer the tutorial:
For deletion, I think it could be simply set to an empty string, but I haven't tried it.
Hope this helps.