number "1" added to filename

Mike

I tried using the code in the link you provided to clear out the temp file.

Each time in run the code it stops at

redim preserve arfiles(count)

and gives the error message 'Compile error variable not defined'

any ideas?

Thanks

Darren

Mike?

That link to the .vbs code is not used in excel's VBA.

Open NotePad
copy Michael Harris's code there.
Save it as
deletetempfiles.vbs
(in a nice safe subfolder)

create a shortcut on your desktop to that .vbs file and double click on the
shortcut.

DarrenWood wrote:
>
> Mike
>
> I tried using the code in the link you provided to clear out the temp
> file.
>
> Each time in run the code it stops at
>
> redim preserve arfiles(count)
>
> and gives the error message 'Compile error variable not defined'
>
> any ideas?
>
> Thanks
>
> Darren
>
> --
> DarrenWood
> ------------------------------------------------------------------------
> DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
> View this thread: http://www.excelforum.com/showthread...hreadid=383664

--

Dave Peterson