AnsweredAssumed Answered

Update Design Table External Links with "Data / Edit Links / Update Values" in Excel

Question asked by M. B. on Aug 19, 2017
Latest reply on Sep 5, 2017 by M. B.

Like • Show 1 Like1
Comment • 3

Can someone show me how to write a macro for the following tasks? I can’t figure out how to Update Values (steps 1-4) within Excel.

- Open Part #1
- Edit Table or Edit Table in New Window

Data
Edit Links
Update Values
Close

- Open Part #2 and repeat steps above

- Open Part #3 and repeat steps above

- Open Assembly #1 and repeat steps above

One method is to have the externally linked Excel file already open before opening the Design Table but this method fails now with the Solidworks message “Insufficient memory to perform operation”. This error message appears on some part/assy. files but not on other files.

No one else has this question

Outcomes

Jeetendra Prasad Aug 19, 2017 2:41 PM

Hi,

This should be able to help you in your task:-

I have created a Free Product Configurator. Sharing to see if this creates buzz or not.

This is created by me. Though not a macro/open sourced software. But suits your requirement for linking and updating model with single excel. Feel free to have more info about that.

Regards,

Jeetendra Prasad

Actions

M. B. Aug 23, 2017 10:18 AM

Do any of the macro experts know if steps 1-4 can be inserted in between the lines below?

Does anyone else use design tables with external links and wants those links updated?

' ******************************************************************************

' C:\Users\xxx\xxx\Macro1.swb - macro recorded on 08/23/17

' ******************************************************************************

Dim swApp As Object

Dim Part As Object

Dim boolstatus As Boolean

Dim longstatus As Long, longwarnings As Long

Sub main()

Set swApp = Application.SldWorks

Set Part = swApp.ActiveDoc

boolstatus = Part.Extension.SelectByID2("Design Table", "DESIGNTABLE", 0, 0, 0, False, 0, Nothing, 0)

Part.InsertFamilyTableEdit

Steps 1-4

Part.CloseFamilyTable

End Sub

Actions

M. B. Sep 5, 2017 12:14 PM

Any chance someone could let me know if it’s possible to select MS Excel commands from within a SW macro?

Is there a better place to post this question?

Actions

3 Replies

Jeetendra Prasad Aug 19, 2017 2:41 PM
Mark Correct
Correct Answer
Hi,

This should be able to help you in your task:-
I have created a Free Product Configurator. Sharing to see if this creates buzz or not.

This is created by me. Though not a macro/open sourced software. But suits your requirement for linking and updating model with single excel. Feel free to have more info about that.

Regards,
Jeetendra Prasad
Like • Show 1 Like1
Actions
M. B. Aug 23, 2017 10:18 AM
Mark Correct
Correct Answer
Do any of the macro experts know if steps 1-4 can be inserted in between the lines below?
Does anyone else use design tables with external links and wants those links updated?

' ******************************************************************************
' C:\Users\xxx\xxx\Macro1.swb - macro recorded on 08/23/17
' ******************************************************************************
Dim swApp As Object

Dim Part As Object
Dim boolstatus As Boolean
Dim longstatus As Long, longwarnings As Long

Sub main()

Set swApp = Application.SldWorks

Set Part = swApp.ActiveDoc
boolstatus = Part.Extension.SelectByID2("Design Table", "DESIGNTABLE", 0, 0, 0, False, 0, Nothing, 0)
Part.InsertFamilyTableEdit

Steps 1-4

Part.CloseFamilyTable
End Sub
Like • Show 0 Likes0
Actions
M. B. Sep 5, 2017 12:14 PM
Mark Correct
Correct Answer
Any chance someone could let me know if it’s possible to select MS Excel commands from within a SW macro?
Is there a better place to post this question?
Like • Show 0 Likes0
Actions

Update Design Table External Links with "Data / Edit Links / Update Values" in Excel

Outcomes

Related Content

Recommended Content