×
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

Macro Enabled Worksheet not Supported

Macro Enabled Worksheet not Supported

Macro Enabled Worksheet not Supported

(OP)
To be Honest I was pretty upset finding this today. I had been working with my VAR and SW waiting on a solution. Its been a month and I was just given today the SPR# 548310.
 
Problem: When I put VBA code, or add buttons to a worksheet then close out the Design Table and reopen it... all the code and code for the buttons are gone and nothing works from a VBA standapoint.

 
I  sat down with it yesterday and found the problem yesterday afternoon. As it turns out in Office 2007 MS released 2 separate work sheet styles Macro-Enabled and Standard Worksheets. Solidworks only allows users the ability to use Standard Worksheets which does not allow the use of VBA code within them. In past version of Office this was not a problem and I made some killer Design Table Spread sheets that really made things easy for the users, but now I can't because we use Office 2007 and SW has limited everyone to only use these cheap standard excel Worksheets.
 
I got in today thinking I will insert my own macro enabled worksheet... nope the only option is *.xlsx, which is the standard worksheet. *.xlsm is the Macro Enabled Worksheet.

I hope they fix this soon and within SW 2011 so when we upgrade to 2011 in June/July I will be able to use this functionality, since SW should have been supporting it since the release of Microsoft Office 2007.

If you use Design Tables or any type of VBA coding in your worksheets, please submit this to your VAR or SW and get this issue moved up the list. This functionality can and is very limiting for not only myself, but anyone that tries to use it. Its a brick wall, that not only myself but others have not been able to get around.
 
Purchasing Driveworks or the SPN software is not an option, not only because of the cost for each user (100+ users here), but also because SW is Microsoft Compliant and this functionality should already exist.

 
Thanks for reading and I hope you submit this bug!
Best Regards,

  

Scott Baugh, CSWP pc2
Berry Plastics
Cad Admin\Design Engineer
www.scottjbaugh.com

Quote:

"If it's not broke, Don't fix it!"
FAQ731-376: Eng-Tips.com Forum Policies

RE: Macro Enabled Worksheet not Supported

(OP)
In case your wondering - Solidworks recently provided me this workaround:

1. Create the design table in Excel
2. Add in the macros
3. From excel, save this workbook as .xls
4. Open your part
5. Delete out your current design table
6. Insert design table using the From File option

The SPR still needs to be fixed so you can use the new functionality of Office 2007.

Best Regards,

Scott Baugh, CSWP pc2
Berry Plastics
Cad Admin\Design Engineer
www.scottjbaugh.com

Quote:

"If it's not broke, Don't fix it!"
FAQ731-376: Eng-Tips.com Forum Policies

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