Cancel
Showing results for 
Search instead for 
Did you mean: 

Re: excel to drive draft.

Pioneer
Pioneer

hiii

 

yes you had to save excel as a macro-enabled sheet.

 

Are you know how to run micros?

 

It is compulsory to open draft file (which scale you want to change) when you run micros. Are you do the same??

 

 

Re: excel to drive draft.

Genius
Genius

Hi Harsh.

 

Sorry for the late reply.

 

No, I don't know how to run the macro.  Google isn't much help.

Re: excel to drive draft.

Genius
Genius

Hi Harsh.

 

When I run the macro from the developer tab I get an error on this line "  Dim oSheet As SolidEdgeDraft.Sheet"

 

See attached file.

Re: excel to drive draft.

Genius
Genius

Hi Guys.

 

I have it working.  Thanks for your help on this.

 

All I want to do now is put a go button on the sheet which will make it easy for everyone to use.

Re: excel to drive draft.

Genius
Genius

Update.

 

Button added and works well.

 

1 issue, my dimension lines become detatched, is there a solution for this?

Re: excel to drive draft.

Pioneer
Pioneer

so It's working now, that's good...

 

sorry for your second questions. i don't know about that.

Re: excel to drive draft.

Genius
Genius

Yes al working thanks for all your help on this.

Re: excel to drive draft.

Genius
Genius

Is it possible to contrain the view on a draft?

 

I want to keep a point in the same place.  When I change the  size of my model then change the scale, I have to move the views back into position. 

Re: excel to drive draft.

Pioneer
Pioneer

Sorry for late reply..

 

Yes it is possible by coding..

 

x & y co-ordinates of the drawing view can be fixed by coding or else you can lock your view.