Excel and Data Importing from Web

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Bryan2306

Thread Starter
Joined
Oct 5, 2001
Messages
18
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
 
Joined
Jun 17, 2002
Messages
2,556
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

Thread Starter
Joined
Oct 5, 2001
Messages
18
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top