My apologies up front as this may seem to be more of an Excel or VB question, but those folks seemed to be stumped so I turn to you, who have helped with similar problems in the past. BACKGROUND: I have an Excel workbook, with many control buttons...
My apologies up front as this may seem to be more of an Excel or VB question, but those folks seemed to be stumped so I turn to you, who have helped with similar problems in the past.
BACKGROUND: I have an Excel workbook, with many control buttons which call macros, which in turn import internet data to the spreadsheet using query tables. All work perfectly except for the following website:
http://wwwagwx.ca.uky.edu/uk_combo.htm
This page contains text or 'headers' and pictures, which seem to also be active links...or something, forgive my ignorance. When I try to query the site, (and I have attached a simplified workbook to do this), I get only the text portion, and not the pictures.
My current 'work around' is to have the macro open the website, then the user is instructed to copy it to the clipboard (press Ctrl & "A", Ctrl & "C") and then return to the workbook to paste it (Ctrl & "V").
What I want to do is have the entire page imported without any extra cutting and pasting on the part of the user.
Any help will be greatly appreciated.
Tom
Attached Files
GetForecast.xls (22.0 KB)
Linear Mode
