Moving Excel code to a new workbook

[mcescher]

Hi All,

I've searched here and mvps.org, and can't come up with an answer, so
any help would be much appreciated.

Through automation, I am pushing query results out to an Excel
workbook, and formating the text some. That part works great. The
excel sheet uses autofilters so the user can select their information.
The top of the sheet has a totals row that automatically updates after
the user has changed their selection via the autofilters. The Totals
are updated by a function that sums only the visible cells. It's a
short piece of code, but very useful for this application.

With all that being said, I need to be able to push that VB code into
the newly created Excel sheet, so that function is available to the
worksheet.

Access 2002, Excel 2002

HELP!!!,

Chris M

 

[Stefan Hoffmann]

hi Chris,

With all that being said, I need to be able to push that VB code into
the newly created Excel sheet, so that function is available to the
worksheet.

Create the new sheet from a template, which contains your code.


mfG
--> stefan <--

 

[mcescher]

hi Chris,

Create the new sheet from a template, which contains your code.


mfG
--> stefan <--

Sometimes the easiest answers are the hardest to see....

That was a genius idea. Thanks!!!

Chris