×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Table in a template Macro?

Excel Table in a template Macro?

Excel Table in a template Macro?

(OP)
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.

RE: Excel Table in a template Macro?

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

Chris
SolidWorks 11
ctopher's home
SolidWorks Legion

RE: Excel Table in a template Macro?

(OP)
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.

RE: Excel Table in a template Macro?

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources