Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application level VBE
Hi,
I wish to use VBE to process all the ducuments currently open in excel. What kind of object do I associate this code with? For example, a macro is used to associate vbe with a document and a key shortcut can be issued to trigger this macro if this doc has focus (is the active ducument). Also, this vbe code resides with the document in question. Instead, I want a button or something in excel which I can press to process my files. I also want to be able to send this button object to a client so that they can install it in there version of Excel. How do I do this? Thanks, Aine. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application level VBE
An add-in.
http://support.microsoft.com/default.aspx?kbid=211563 How to create an add-in file in Excel 2000 -- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message ups.com... Hi, I wish to use VBE to process all the ducuments currently open in excel. What kind of object do I associate this code with? For example, a macro is used to associate vbe with a document and a key shortcut can be issued to trigger this macro if this doc has focus (is the active ducument). Also, this vbe code resides with the document in question. Instead, I want a button or something in excel which I can press to process my files. I also want to be able to send this button object to a client so that they can install it in there version of Excel. How do I do this? Thanks, Aine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application level event help | Excel Discussion (Misc queries) | |||
Application level events | Excel Programming | |||
Application Level macros | Excel Programming | |||
Declare at application level | Excel Programming | |||
Application Level Events Question | Excel Programming |