Excel Table in a template Macro?

[var10]

Hi

I am looking at having a excel table in my drawing template which will save the spreadsheet under the same name as the part file's name in Solidworks each time I use this template.

Also I want this table to be shown in the drawing (not just as an attachment). Is this possible? Are there any macros?

The reason being the drawings need to be approved and filled in the revision table by someone other than the person who produced the drawing. So I thought it would be a great idea if I could link the revision table to an excel spreadsheet and whoever is going to check the drawing can just open up the spreadsheet, enter their initials and when I open the Solidworks drawing it updates automatically.

Any other suggestions and ideas are also welcome.

Thanks for any help.

 

[ctopher]

Insert Object/check Create from File/check Link box/browse to Excel file

Chris
SolidWorks 11
ctopher's home
SolidWorks Legion

 

[var10]

Thanks Chris. I know how to insert a excel sheet. The problem is that I want it to have the same name as my drawing.

What I mean by this is everytime I save a new drawing I want an excel spreadsheet to be saved at the same location under the same name. I don't want to do them manually everytime I create a drawing instead I want it to be embedded in my template and do it for me to save time.

 

[ctopher]

OK. The only way I know is manually.

Chris
SolidWorks 11
ctopher's home
SolidWorks Legion

 

[mmarston]

Make the reevision table boxes, custom properties.
The reviewer can open the properties from explorer, go to the custom properties tab and enter their intials, this will be saved with the file.