hi all

not clear where to put a program for excel.

i write it using the vbeditor, using the vba language but then.... where
do i put it? in a cell? in a macro? outside excel as a vbscript?


i'm confused


thanks]

From Excel:
Touch ALT-F11 to open VBE
Touch ALT-i
ALT-m

to open a fresh module.

Put your stuff in there.
--
Gary's Student - gsnu200742


"console1" wrote:

hi all

not clear where to put a program for excel.

i write it using the vbeditor, using the vba language but then.... where
do i put it? in a cell? in a macro? outside excel as a vbscript?


i'm confused


thanks]

If you've already written it in Excel's VBA Editor, then it is contained in
a workbook in Excel. That's where it stays.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"console1" wrote in message
...
hi all

not clear where to put a program for excel.

i write it using the vbeditor, using the vba language but then.... where
do i put it? in a cell? in a macro? outside excel as a vbscript?


i'm confused


thanks]