Jon's code is a macro that's run from inside excel.

Application is Excel (itself) and Activecell is a range object within excel.
Activecell represents the cell that's selected (or if the selection is
multi-cells, it represents the "white" one in that selected area).

You may want to read David McRitchie's intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

wrote:

Hi Jon,

Thanks for replying. I'll go figure this out, but if you have a second
can you explain where the Application and ActiveCell objects come from?
I was just writing directly to Response.Write, setting the content type
to excel, and letting Windows just open the file naturally from the
association. It looks like you're directly manipulating excel, which is
an avenue I haven't investigated before.

Thanks again,
Orlando

--

Dave Peterson