How to Close a Design Table in VBA? 2

[SBaugh]

I know I have done this before and I am fairly certain it stupidly simple, but I can't remember or find in on the web.

I have a button on my design table and I just want to close the design table when I click. what the VBA code to do that?

Scott Baugh, CSWP
CAD Systems Manager
Evapar

http://www.evapar.com

"If it's not broke, Don't fix it!"

faq731-376

 

[handleman]

I'm not sure... Of course, any button on a design table will have to run code that resides in Excel rather than SolidWorks... It may be as simple as telling Excel to close. I'm not sure exactly. It may be as complicated as having to connect to SolidWorks (GetObject) and telling SolidWorks to close the design table.

 

[SBaugh]

I don't recall having to use any API callouts in the past. I think you might be right, it might be as easy and telling excel to Close. Do you know what that code is? is it as easy as "Excel Close"?

Scott Baugh, CSWP
CAD Systems Manager
Evapar

http://www.evapar.com

"If it's not broke, Don't fix it!"

faq731-376

 

[handleman]

Probably like Application.Close or something. Just type "Application." and pick one that looks closey or exity.

 

[GRF]

As a person who knows next to nothing about programing I had a good chuckle at handleman's answer.

 

[handleman]

Well... I popped open Excel and took a peek. It's Application.Quit.

 

[SBaugh]

Thanks Handleman!!

Scott Baugh, CSWP
CAD Systems Manager
Evapar

http://www.evapar.com

"If it's not broke, Don't fix it!"

faq731-376

 

[handleman]

No prob! For my own edification... did that work to exit the table?

 

[SBaugh]

Yes it does.

Scott Baugh, CSWP
CAD Systems Manager
Evapar

http://www.evapar.com

"If it's not broke, Don't fix it!"

faq731-376