Pass date as parameter

[jTrader]

Hi,

I'm trying to pass a date as a parameter. On the receiving side it looks like this:


Sub GenerateSimpleReport(EndDate As Date, TargetSheet As Integer)
.
.
.
End Sub


How would I pass in this value? It doesn't accept, say, GenerateSimpleReport(10/20/2007, 5). It seems to treat the supposed date as a computation or something.

Thanks for any insight!

Jeff

[JKwan]

Try this:

Sub GenerateSimpleReport(EndDate As Date, TargetSheet As Integer)
MsgBox EndDate
MsgBox TargetSheet
End Sub
Sub test()
GenerateSimpleReport "2/3/2009", 6
End Sub

[jTrader]

Thanks, that worked.

[mdmackillop]

Hi jTrader,
If your question is Solved, please mark it so using the Thread Tools dropdown.
Regards
MD