1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel and Data Importing from Web

Discussion in 'Business Applications' started by Bryan2306, Apr 17, 2004.

Thread Status:
Not open for further replies.
  1. Bryan2306

    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
     
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,551
    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.
     
  3. Bryan2306

    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.
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/221338

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice