Compile Error Variable not Defined

**Mooseman60** · 11-16-2010, 08:07 AM

In the following code i am getting an error saying variable not defined in this line

SaveName = mydir & "\" & txtJobNo.Value & ".xls"

Please Login or Register  to view this content.

**romperstomper** · 11-16-2010, 08:15 AM

You haven't declared SaveName - you need to add:

Please Login or Register  to view this content.

**Mooseman60** · 11-16-2010, 10:08 AM

Romperstomper

Now it comes up with the following error: invalid use of Me keyword

Please Login or Register  to view this content.

**romperstomper** · 11-16-2010, 10:13 AM

Where is the code? That will only work in a userform.

Re: Compile Error Variable not Defined