calling all eagle eyes!
What could be preventing the value of the third variable (EndDate) from being returned when called by this For Each?
#
TempVars("gtvUserName").Value = "John Smith"
TempVars("gtvUserFolder").Value = Environ("HOMEPATH")
TempVars("gtvEndDate").Value = Format(Now(),"mm/dd/yyyy")
For Each gtv in TempVars: Debug.Print gtv.Name & ":" & gtv.Value:Next
gtvUserName:John Smith
gtvUserFolder:\Users\Amy
#
(note: in my code there is no space between : Debug, but I had to add the space here to avoid an emoticon showing up)
I'm working through some lessons in a book that already has had one typo that I had to correct. Here, I can't fathom what might be going on because I can't see any difference between how all the variables are declared.
thanks in advance for tips.
cheerios
amy