Setting up Excel addins

[jkpieterse]

Hi,

I've published an article hwo to use SF to install Excel addins:

www.jkp-ads.com/articles/AddinsAndSetupFactory.asp

[jcuster]

changing an existing macro either in Excel or Word using SUF or VB?

The scenerio is that I need to change the Printer pagouts from tray #s to actual Paper Sources. I don't wan't to edit each user's VB scripts..

[jkpieterse]

You can change VBA code from VBA.

You need:

- a reference to the "Microsoft Visual Basic for Applications Extensibility 5.3 library"
- Have your users set Tools, macro, security, trusted sources tab, check "Trust Access to Visual Basic Project"
- Then run your code

Sample code for modifying VBA code through VBA can be found e.g. on Chip Pearsons pages: http://www.cpearson.com/excel/vbe.htm.