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

I think you can include internet explorer active x object into a word doc. if not, you can certainly add a hyperlink to it.

I think you can also choose INSERT OBJECT and then CREATE FROM FILE and point it to you URL.

Hope this helps some,
Chi

somebody, 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.