Excel and Data Importing from Web

[Bryan2306]

I have a project at work where I need to import data from a web page into a worksheet in excel. Somehow this needs to be automated to where the required data is only entered in excel, this information must be entered into fields on a web page, and then an ascii data file must be copied from the subsequent web page into a spreadsheet.

Does anyone know if this can be done? The link for the web page I'm using is below.

U.S. Naval Observatory

 

[Ziggy1]

Post more details about how your data is processed. Do you have access to an Ascii file directly or are you just copying and pasting the computed results from the page?

A Macro can be recorded to from Excel to grab the file and sort it the way you want.

 

[Bryan2306]

The website I'm refrencing takes a location defined by latitude and longitude and calculates a table of sunrise and sunset times for a year at that location. This table is the ascii file I need to copy to excel.

The data (year, city or longitute and latitude) would be entered into an excel spreadheet, either directly or with a user form. This data needs to be transferred to the webpage, and then the required data table copied from the page.