Hello everyone: it has been years since i have touch vba and it appears what i knew back in the day no longer works in todays world lol... anyway here is what i am trying to do. I create new tabs everyday in an excel spreadsheet and name it ex. 20130531. i am trying to create a string that will allow me to call this page so i can gather data from it. i keep getting the value 5/31/2013 so it is not locating the tab. i have tried converting the date in the spreadsheet itself however it keeps giving me the wrong value as well.
Can anyone help?
Thanks
Tom