Jeff Brown Male United States: Share on Facebook Share Twitter

Blog Posts
Discussions (5)
Events
Groups
Photos
Photo Albums
Videos

Jeff Brown's Apps

Jeff Brown's Discussions

SW link to Excel
9 Replies

I am trying to directly link a curve or line in SW to a table in Excel. It can be done by storing the table as a text file and then loading it as a spline but this gets old fast if you have 30 or 40…Continue

Started this discussion. Last reply by Deepak Gupta Sep 23, 2010.

View All

Jeff Brown's Page

Gifts Received

Jeff Brown has not received any gifts yet

Give Jeff Brown a Gift

Latest Activity

Deepak Gupta left a comment for Jeff Brown

A birthday is just the first day of another 365-day journey around the sun. Enjoy the trip HAVE A BLAST MANY MANY RETURNS OF THE DAY !!HAPPY BIRTHDAY!!

Sep 24, 2010

Deepak Gupta replied to Jeff Brown's discussion 'SW link to Excel'

Hi Jeff, sorry for missing out the post and losing the track. Were you able to fix the issue.

Sep 23, 2010

Jeff Brown replied to Jeff Brown's discussion 'SW link to Excel'

That would be wonderful. I'm sorry to be such a pain, but I have atleast a year invested in this project and a break through in this problem will be a great, great step forward. Jeff

Feb 13, 2010

Deepak Gupta replied to Jeff Brown's discussion 'SW link to Excel'

Jeff, I have SW2006 on one of my machine and I'll see if I can fix the macro.

Feb 12, 2010

Jeff Brown replied to Jeff Brown's discussion 'SW link to Excel'

Thank you, Thank you for your macros. I finally engaged my brain, with your help, and have both of then now. The only remaining problem seems to be that I am too far out of data. I am still using SW 2006 and I do not havethe necessary Libraries to…

Feb 12, 2010

Deepak Gupta replied to Jeff Brown's discussion 'SW link to Excel'

Jeff, These are macro files and you can run then by clicking run on the macro toolbar or Tools > Macro > Run. Your other post says that you were able to run the macro by Ray so did you had any chance with these macros.

Feb 12, 2010

Jeff Brown replied to Jeff Brown's discussion 'SW link to Excel'

Thank you Ray. I was able to retrieve your macro and I did attemp to run it. As you might guess I am using SW 2006 and several of your lines of code were a problem. " Dim sketchFeat As Feature", and it didn' like "If Mid(dataStr,…

Feb 11, 2010

Jeff Brown replied to Jeff Brown's discussion 'SW link to Excel'

Thank you Deepak so much for your information and the effort you have made to help me. Unfortunately I am only a Newbe Geek and I have had no luk extracting these files. They come as .SWP files and I have been unable to find anything that will open…

Feb 11, 2010

Deepak Gupta replied to Jeff Brown's discussion 'SW link to Excel'

Check this one too https://forum.solidworks.com/message/142483#142483

Feb 11, 2010

Deepak Gupta replied to Jeff Brown's discussion 'SW link to Excel'

Check these two macro if they help you http://www.angelsix.com/cms/solidworks-macros/39-surfplot http://www.angelsix.com/cms/solidworks-macros/27-funcplot

Feb 11, 2010

SW link to Excel

Discussion posted by Jeff Brown Feb 10, 2010

9 Comments

Jeff Brown is now a member of SolidWorks Geeks Feb 10, 2010

Welcome Them!

Profile Information

What version of SolidWorks do you currently use?: 2006

How many years have you been using SolidWorks?: 2

What certifications do you have? (CSWP, CSWA, ETC...): None

What other programs do you use?: Excel

What are you running SolidWorks on?: Dell Precision M4500

What field do you work in?: Musical Instrumsnts

What are some of your group affiliations?: None

What do you hope to gain from SWGeeks.com?: I need to determine if and how a curve or line can be driven directly from a table in Excel without first exporting the table to a text file and then importing it to SW. Other CAD software can do this I I expect SW can as well. But so far I've not been able to do so. Thanks, Jeff

How did you hear about SWGeeks.com?: I Just Went Looking

Comment Wall (1 comment)

You need to be a member of SolidWorks Geeks to add comments!

Join SolidWorks Geeks

At 12:21am on September 24, 2010, Deepak Gupta said…: A birthday is just the first day of another 365-day journey around the sun. Enjoy the trip

HAVE A BLAST

MANY MANY RETURNS OF THE DAY

!!HAPPY BIRTHDAY!!