Read data from an htm file

M

Mayank Gupta

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
 
N

NickHK

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

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I print payslips from an excel spreadsheet? 1
Macro to create a new tab based on an existing tab 1
VBA to copy an htm file into excel 4
Print pooling 1
Save As HTM with "align=Left" in HTM file code 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Data from web-sites 3
Pulling data from one workbook to another one using VBA 0

Top