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
Does anyone know if this can be done? The link for the web page I'm using is below.
U.S. Naval Observatory