|
Answer» Hello,
How can I include a table from a website (it is dynamic) in a Word doc using macro?
I use Visual Basic. I know that 'IncludePicture' can be used for dynamically getting pictures from websites, but this is a table and i'm lost ...
Usage: When the macro is run, a report will be created with the latest table.
Thankssomebody (in some other FORUM), suggested that I use Excel's
web query feature to extract the necessary tables.
(Data -> get EXTERNAL Data -> New Web Query)
It seemed like it might just work .. BUT! You need a username and password to enter the page.
How can I make this work?
I have SEEN examples somewhere when SOMEBODY inserted the password along with the web address .. How can this be done?
Also .. IF I do manage to extract the table to Excel, I would still need to transport the table to my Word Document .. I am quite new to macro CODING .. so ANY help would be appreciated ..
Thank you. (If you reply)
|
