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