I should have given a bit more info, sorry. The data is currently
being entered via an input box. I was envisioning a way to do it with
no input box, using only variables to get at the date.

Tim




Norman Jones wrote:
Hi Tim,

If I understand you, try:

'=============
Public Sub Tester()
Dim res

res = InputBox(Prompt:="Enter date", _
Default:=Format(Date, "yyyymmdd"))

If IsDate(res) Then res = Format(res, "yyyymmdd")

'your code

End Sub
'<<=============



---
Regards,
Norman



wrote in message
oups.com...
I have an Excel report that I have to run every day. It requires one
piece of manually entered data. I have to type in the date in the
format yyyymmdd (ex. 20060713). If I could figure out a way to get
this data into the program automatically, then I could set the macro to
run on a schedule and I wouldn't have to do it every morning.

Any help is appreciated.

TIm