×
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

Edit with Excel in r2001

Edit with Excel in r2001

Edit with Excel in r2001

(OP)
I want to have a macro in excel so I can use it when proe starts excel from the instances box....

I copy a template into the xlstart folder of office... and if I run excel any other way my macro is there

but not when proe starts it

does pro look somewhere else????

I see a bunch of excel files that seemed to be save when I update to pro and the are in a folder
C:\Documents and Settings\Your name\Local Settings\Temp

is that where I need the template???

RE: Edit with Excel in r2001

Is there anything helpul in the FAQ Using Microsoft Excel with Pro/ENGINEER (FAQ554-905)?

Best regards,

Matthew Ian Loew


Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.

RE: Edit with Excel in r2001

(OP)
Good stuff to look over, but no answer to the problem.

But it seems that the way excel starts from the proe instances box is as some form of a temp file.... but if you load your vba form and bas file it will remain in excel through out your proe session.. at least under r2001
you just want to put them under that yard long directory name that excel defaults to.


VBA doesn't do control arrays like vb... there is a work around in the vba forum here.

I'm getting close to off topic from ProE, but wanted to pass on what I discovered...macros in family tables

RE: Edit with Excel in r2001

(OP)
It just might be the way excel handles VBA or the way both ProE and SolidWorks handle excel.

In order to get ProE to remember what edits you may make in your excel macros you have to edit at least one item on the worksheet, you can export the .frm or the .bas file and they will be saved, you will have to reload them tho.unless you edit something on the sheet.

If you edit something on the sheet.. x to close ..prompt comes up to update proe...yes...then the edits takeand next time you use excel to edit table verything is there, you don't have to reload frms or bas files

this may be old hat to seasoned excel users, but I found out the hard way.....so just passing it on

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