View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Read data from an htm file

You can read the files from the web site (assuming they are accessible) in
Excel with DataImport External DataNew Web Query.
You can also get local files, but remember you need to "file" instead of
"http".

NickHK

"Mayank Gupta" wrote in message
...
Hi,

I want to be able to read data from a .htm file into an excel workbook.

The problem I am trying to solve is that my payslips are hosted on a web
server and for doing my tax analysis etc. I need the data in excel. I have
downloaded the payslips from the web and I now need to import that data

into
excel.

Can anyone help me with this please?

Regards
Mayank