Edit with Excel in r2001

[cadcamguy]

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???

 

[mloew]

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.

 

[cadcamguy]

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

 

[cadcamguy]

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