Excel + Publisher

[caioac]

Hello,
I have a document in Publisher with about 5 tables, and a spreadsheet in Excel that have all the data that I need.
I have been trying for ages to program a VBA that automatically copies certain cells in Excel, and pastes it in the assigned tables in Publisher.
Any help will be more than welcome, I'm stucked for a while here.
Thank You very much.
Cheers.

[JP2112]

First you'll want to instantiate Publisher. See http://www.codeforexcelandoutlook.com/blog/2009/02/easy-applicationobject-references/ for sample code.

The Publisher VBA reference may be found here: http://msdn.microsoft.com/en-us/library/aa211693(office.11).aspx