Solidworks Automation using Excel Add in

[@luisamaral7689]

Great Add-in Engineering Automation. I have some problems to install and save the program, but with the resource of videos on KZbin, i as capable to add in to excel. I dont undestand nothing of Codes, and programming but it was easy. Thanks dude, will help me a lot !

[@dimitarhristakiev6610]

Would you lease make a video how to install thiss add in.

[@engineeringautomation8585]

Thanks for all interest in the application. I've started adding some updates to the ui. The settings in solidworks tab now contains the selection for the units the app will feed into solidworks.

[@MrFreaky1989]

Thank you for all the work you put into this, the install is tricky and holding me up but I'll keep following you to see what you come up with in the future.

[@NiculaGeorgeStefan]

Hi, it is a great tool, I wanted to try it out too, and after a bit o struggle to install it I get this error: Exception from HRESULT: 0x800A03EC Does anybody knows why and how to resolve it?

[@aplied115]

I have managed to get the vsto to run and open Solidworks with no errors but the "solidworks build" and "inventor build" tabs are not displaying. Do you know why this is?!

[@hypertool35]

hi, whats the difference from inserting "design table" ?

[@92Trane]

Hello Engineering Automation, Thank you for openly sharing your work ! I really appreciate it. I've been watching so many tutorials to looking into API to do exactly this. I'm not a developer. I am terrified ! Perhaps you could help? I downloaded and opened the .sln file in Visual Studio. It is showing : "...\SolidworksWrapper\SolidworksWrapper\SolidworksWrapper.csproj : error : The project file could not be loaded" It says the same thing with InventorWrapper. ...I have no idea what a "Wrapper" is. I don't listen to rap music much. Could you clarified on how to get it to work ? Thanks in advance. TR

[@engineeringautomation8585]

Without getting to complicated a wrapper is section of code that wraps another. The reason for wrapper is to make talking with cad applications easier and manage memory.

[@engineeringautomation8585]

The next step will be downloading the inventor wrapper and solidworks wrapper from github the visual studio will be able to find the projects and compile.

[@92Trane]

Hey man, Thanks again for sharing the project. For the people who got stuck: 1) Download the Inventor/SolidWorks wrapper from this link: github.com/jraleighdev?tab=repositories 2) Open up InventorWrapper.sln 3) Add reference to the Autodesk.Inventor.Interop.dll This file is located at where you installed Inventor. If you don't have Inventor, there is a copy of the file in AutomationDesigner/References (from zip) 4) Open AutomationDesigner.sln. Reload the 2 wrappers. Add references to the Syncfusion from Nuget packages by: ... Finding the name of each and install them. All the reference files should be gray (no yellow). 5) If you want to run debug to see what's going on in the code, Open Properties of Automation Designer. In "Debug" tab, select start external program and link to "EXCEL.exe" on your machine. 6) Enjoy the power.

[@davidbaumgartner146]

nice work!

[@aliallaw5529]

This add in th realy helpfull Thanks for sharing with us But i dont under stand codes and programing.. Is there a simple way to install this program easilly

[@abhishekdubey1162]

Hi, Can you please share details videos of how you have created all the options in Excel for this

[@alomara2776]

hello this is a great tool !!! but how can i install it ?

[@arieloliveramedina6553]

Como hago para tener en Excel ese icono de construir?

[@ericoskar6138]

please help to install for a week already trying it does not work

[@RoshanShandres]

Can this add in be added to WPS office?

[@caioyoshiaki764]

Would you by any chance share this excel Add-In ? hahah

[@engineeringautomation8585]

github.com/jraleighdev/AutomationDesinger

[@xihuahe745]

@@engineeringautomation8585 Hello how did it install？

[@nekadaracikdegilmi]

@Engineering Automation Sorry for too many questions. I asked this under another video but it is related to this video. After using this addin to control assembly, if i copy the assembly with all parts (like pack and go) will i be have control on new assembly and new parts by new Excel or the old one?

[@engineeringautomation8585]

You can use any excel sheet as long as the part number matches the open documents structure. It doesn't have a link like design tables do. So its pretty flexible on that.

[@nekadaracikdegilmi]

@@engineeringautomation8585 Thank you very very much! Would you please demonstrate other commands (for example 'equation') how to use? And do you mind if i ask your e-mail? Thank you again for this amazing addin!

[@engineeringautomation8585]

@@nekadaracikdegilmi Sure thing working on making a new video to explain all the commands! I working on some drawing automation for a future release.

[@nekadaracikdegilmi]

@@engineeringautomation8585 Great news!

[@xihuahe745]

Hello how did it install？

[@engineeringautomation8585]

The addin is a vsto addin built using visual studio. Vsto addins can be installed using oneclick or a custom installer.

[@nekadaracikdegilmi]

Helo... me again. I tried a lot but i can't figure out. If i command to suppress ( S ) a part in an assembly, then build process end up with an error that can't find the supressed part. Would you help me about it please if posibble.

[@engineeringautomation8585]

Could you open as issue on github with the stack trace?

[@nekadaracikdegilmi]

@@engineeringautomation8585 Hi.. i sent an email and opened an issue but didn't get any return. Hope you are fine.

[@xingminzhong5368]

Can you package and publish the program? I'm not a programmer. I can't install the program in GitHub.

[@engineeringautomation8585]

Maybe in the future this project is still under active development. Hosting the deployment is not free so i would had to have charge for deployed version. Thanks for interest.

[@xingminzhong5368]

@@engineeringautomation8585 I'm looking forward to your release

[@StudioIngegneriaFabioPic-yo2vx]

Hello Engineering Automation, very interesting add-in. I have downloaded the files but i dont understand how to install the application in excel. Could you give intructions to do it? Shall i subscribe a plan, make a one-time-payment or other? thank you very much.

[@mustafagimy5942]

Hello ! May you help me to install that addin it's very helpfull

[@ericoskar6138]

Can't install talking error

[@engineeringautomation8585]

Please raise an issue on github with stack trace included i can't help with out more information.

[@adamboleskavsky9415]

Hello Engineering Automation, I'm a big fan of your work. This tool is exactly what I am looking for :D. But I have an issue with running this add in. In advance, I want to say that I'm not a developer :D. When I open it in Visual studio, and try to compile, it will send me 70 errors and all of them are CS0246. I downloaded wrappers and placed them correctly. The files that cannot reach are where they are supposed to be, I think. Can you please help me to fix it? Thank you in advance ;)

[@engineeringautomation8585]

The only thing that comes to mind initially is making sure you have the correct version of the dotnet framework installed. It that doesn't help let me know at github.com/jraleighdev/AutomationDesinger

[@engineeringautomation8585]

Well another thing came to mind lol. The ui is powered by some syncfusion tools they are free to download you can create an account use them for any open source project.

[@nekadaracikdegilmi]

@@engineeringautomation8585 Hello Engineer Automation, thanks for this useful tool. Can you please help me to compile the project? I'm getting same CS0246 errors. Also tried "advanced installer" but i get different errors on that too. Thanks in advance and thanks for the tool again.

[@nekadaracikdegilmi]

Nevermind i solve the problem. The problem was syncfusion files in project were in false condition. When i change their condition to true errors are gone :) I just want to ask something; dimension values on excel are comes to solidworks inch type. How can i change it mm?

[@engineeringautomation8585]

@@nekadaracikdegilmi So units are handled in the solidworks wrapper. I haven't implemented user setting in ui. You can uodate the default units in wrapper. Solidworks using meters as its internal units through the api we have to convert to desired units.

[@ericoskar6138]

thanks for the video but show me how to install this plugin

[@engineeringautomation8585]

There is a couple training videos on how to install the app. It currently works as a VSTO add in the that requires visual studio. I don't have a deployable made for the add in at this time.

[@Mambocha35]

@@engineeringautomation8585 can you help ? ı couldnt find any videos. do you have any suggestions videos ?