Word Macro .. help needed ..

[arul20]

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.

Thanks

[arul20]

somebody (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)