Hi,
I am trying to pull information from the web through a web query. The code I have is
For some reason when I try to change the dates (only the "to" date) using a variable the query stops working. I have made sure that it is in the correct format and everything too. Can someone help me out here? I have highlighted the variable in the URL
Please Login or Register to view this content.
Thanks
Last edited by JimmySmith; 04-18-2012 at 02:43 PM.
Forgot to add that The reason I need to change the dates to pull a different range of information according to the current date and I would like to do this all through VBA rather than copy and paste information. The numbers represent the way the website increments different days.
Hello JimmySmith ,
Change the type of the variable dblToday from a Double to a Variant.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Works perfect now! thank you very much!
Hello JimmySmith,
You're Welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks