Re: To Joe Fallon - tried, but no work.

From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 02/21/04 

Date: Sat, 21 Feb 2004 01:04:58 -0500

Try putting the code from
http://www.mvps.org/access/modules/mdl0006.htm
in a Module.

Be sure to get the other download that is mentioned and place it in a module
too.

Give the modules any names EXCEPT any of the functions or subs in them!
Use Module1 and Module 2 for safety.

Then be sure to add a Reference to Excel in your code.
Tools, References.

Good luck. 

-- 
Joe Fallon
Access MVP
"jdtivoli" <anonymous@discussions.microsoft.com> wrote in message
news:12c2601c3f668$26a47690$a601280a@phx.gbl...
> I tried running the first sample you referred me to
> (http://www.mvps.org/access/modules/mdl006.htm).  No
> luck.
> I set it up as a control button on a form in a sample
> database.  When I clicked on the control button, I
> received and error message saying "Compile Error - Sub or
> Function not defined".  Then it highlights the Sub
> sTestXL_Click() title.
>
> Next I tried the following sample;
> (http://support.microsoft.com/default.aspx?scid=kb;en-
> us;14276 Entitled Using Automation to Create and
> Manipulate and Excel Workbook)  No luck here either.
> I set it up exactly as the sample showed.  But I received
> an error saying "Compile Error - Variable not defined".
> Then it highlights the next to the last line of code
> which says Text1.SetFocus
>
> Help please,
>
> Jesse
>