Hi guys,

This is NOT some kind of homework. It's a real project and in The
Real World, you do as you are told by your superior. I rarely used
Excel for development and have never developed 'applications' in
Publisher but I was asked by my boss to develop an Excel application
for some of our staff in the field so they could collect data from
the various restaurants and generate and print a feedback report in
Publisher for each visited restaurant.

Microsoft Publisher was selected as a reporting application because
(1) the client wanted a number of features, like linked boxes, and
(2) the client insisted they wanted the report done in Publisher.

Publisher's Object Browser is not very helpful. There is nor Macro
recorder in Publisher and when I click Help button that takes me to
Microsoft's help site, I receive the following "helpful" error.

"Developer help for Office 2007 and Office 2010


The content youre looking for is no longer online; however, it's
still available offline. Change the connection status to see the Help
topic."

Not very helpful at all.

I was hoping that someone already did something with Publisher from
Excel but I am obviously wrong so I'll just try to figure what to do.

Thank yu for your suggestions.

I apologize for the assumption if same has offended you!

As I stated earlier.., better to seek help about automating Publisher
in a forum for Publisher.

If you understand Excel VBA and OLE automation then doing what you want
certainly can be done as an Excel application. Getting the refs for
Publisher isn't difficult so long as you know how to identify the
objects you want to utilize. With the requirements you've cited so far,
you haven't stated anything that can't be done entirely in Excel;
-especially since you want an application-level solution developed for
your client. Probably best you either upgrade your skills, hire someone
with the skills, or contract an Excel Application Developer to do this
for you.

We are here for you if you choose to elevate your skills...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion