The target file is on my computer although its name changes twice a week.
If I use a web query it tells me there is no data. If I manually select the
contents then copy and paste it into my spreadsheet all the data is there.
What I want to do from within an excel macro:
1. Open the htm file selected by the user ie 12mar.htm (when I do this
manually it opens in IE - my attempts to reproduce this with vba have failed
miserably)
2. Select and copy the file contents (the whole page is fine)
3. paste it into a specific sheet (called "Hands") in my workbook.
4. Close the htm file and return to excel/continue with the macro I've
written

(From this stage I've already got the macro to place the data in the correct
areas on another sheet ready for web uploading)

Thank you to anyone who can offer assistance