Happy New Year everyone. Mine certainly was...except, I have programs that update annually on Jan 1 and one of the URLs that I need has changed. I'm very weak when it comes to reading HTML source code, but it looks like I've included everything...
Happy New Year everyone. Mine certainly was...except, I have programs that update annually on Jan 1 and one of the URLs that I need has changed. I'm very weak when it comes to reading HTML source code, but it looks like I've included everything required..but I guess not.
Background: I'm using an Excel spreadsheet with a macro that populates a URL for a querytable. The actual website I am accessing is:
http://aa.usno.navy.mil/data/docs/RS_OneYear.php
I'm using FORM A where Year = 2009, Type of Table = sunrise/sunset, State or Territory = North Carolina, and the City or Town Name = Rolesville.
The URL have used in the past for this qurery is:
URL;
http://aa.usno.navy.mil/cgi-bin/aa_r...sville&ZZZ=END
This should produce the sunrise/sunset table but now it tells me there is probably a formatting error.
Can one of you please look at the source code and tell me what I'm doing wrong.
Thanks so much,
Tom
Linear Mode
