Using Publisher macros to extract info from other Publisher file 1

[Grahamsp]

Hi
I am trying to use a macro in MSPublisher 2010 to extract information from a table in another Publisher file on the hard drive. I can extract information from an ordinary text file but do not know how to get info from a shape inside a Publisher file. If it is necessary to run the file on the HD then thats fine. Any ideas.

Thanks in advance

Grahamsp

 

[kjv1611]

You probably will need to reference the Publisher object. I'd look there first. Sorry I can't specifically give you any code on it, as I've not used VBA for anything in Publisher.

Here are a couple references I grabbed that hopefully will provide some assistance to finding your answer:

http://msdn.microsoft.com/en-us/library/aa168488(office.11).aspx

http://www.microsoft.com/downloads/...d2-a46a-49e2-80f8-23a36fdf3af3&displaylang=en

Though I've seen a couple questions on Publisher VBA of late, and it's got me curious, thinking about it. Maybe one day I'll take a look at it myself, but I don't have a specific need, so it's not as likely.

The way Office VBA works is there are are objects and properties of said objects.

So in a Publisher doc with a table, you'd probably have a Publisher Doc/Sheet object, and then you'd have a Table object within said Doc/Sheet object. Then within that table, you'll have rows/columns/records/fields.

And now after some more digging, I think I may have found what you need:

http://msdn.microsoft.com/en-us/library/aa212005(v=office.11).aspx

This talks about using the Stories object in Publisher to access all info within a Publisher file. Give that a shot!

Report back with your progress.

 

[kjv1611]

Oh by the way, being that Publisher is not MS Access, this question would have best been posted in forum707 being as that's the more general forum for using VBA in Office programs other than Access.

Just as a hint: I don't think very much use of VBA is made in Publisher when compared to other Office products. Therefore you'll have a harder time finding help for it.