ashleyuk1984
07-27-2015, 10:03 AM
Hi,
I'm basically trying to return a value from the Locals window. I'm getting there, but I just can't seem to get the last step correct.
This is what my Locals window looks like.
http://i.imgur.com/gWekTHL.png
I'm trying to grab information from this block of information.
(I've crossed out all of the confidental stuff)
I can grab the information highlighted below (01. January) by just using this:
Debug.Print queue.Item(1).Name
http://i.imgur.com/H98eokT.png
However, I'm trying to go a little bit deeper.
I'm trying to return this value.
http://i.imgur.com/7cqxZuH.png
I've tried several combinations, and also the obvious one (to me anyway) which was:
Debug.Print queue.Item(1).SubFolders.Item(1).Name
But that doesn't appear to work. I'm getting error "Run-time error 5: Invalid procedure call or argument"
I can't seem to grab that information of "2601"
Please help.
Thanks
I'm basically trying to return a value from the Locals window. I'm getting there, but I just can't seem to get the last step correct.
This is what my Locals window looks like.
http://i.imgur.com/gWekTHL.png
I'm trying to grab information from this block of information.
(I've crossed out all of the confidental stuff)
I can grab the information highlighted below (01. January) by just using this:
Debug.Print queue.Item(1).Name
http://i.imgur.com/H98eokT.png
However, I'm trying to go a little bit deeper.
I'm trying to return this value.
http://i.imgur.com/7cqxZuH.png
I've tried several combinations, and also the obvious one (to me anyway) which was:
Debug.Print queue.Item(1).SubFolders.Item(1).Name
But that doesn't appear to work. I'm getting error "Run-time error 5: Invalid procedure call or argument"
I can't seem to grab that information of "2601"
Please help.
Thanks