View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JJF JJF is offline
external usenet poster
 
Posts: 10
Default personal.xls and add-in

On Apr 27, 9:02*pm, JJF wrote:
On Apr 27, 8:55*pm, JJF wrote:





On Apr 27, 8:41*pm, "Peter T" <peter_t@discussions wrote:


It's probably better to distribute and maintain/update an addin.


There are some small differences in the VBIDE object model in Excel97, but
in Excel 2000-2007 it's the same for all versions, AFAIK.


Since 2002/XP you need to check "Trust access to VB Project"


Regards,
Peter T


"JJF" wrote in message


....


I need to insert on personal.xls of 4 computers 3 routines, that need
maintenance often.


is it possible to use a file (i.e. an add.in that i use for personal
menu) to do it?


i can also remove all module.bas and replace them


i tried with appilcation.vbaprojects compomnents a s idid in the past
but on office xp must be different syntax.- Hide quoted text -


- Show quoted text -


ok thanks- Hide quoted text -


- Show quoted text -


Excuse me, what do you mean with "Since 2002/XP you need to check
"Trust access to VB Project" *?- Hide quoted text -

- Show quoted text -


sorry sorry i'm dummy, found it thank you