macro in Publisher to open an Excel file? can it be done?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce - 27 Mar 2005 16:33 GMT

I am trying to use a macro in Publisher to open an Excel file that is a data
source for a catalogue merge. Is this possible? I am not very familiar with
visual basic. Right now I have exported some data from Filemaker into an
Excel text file. I am using publisher's catalogue merge feature and I am
trying to simplify the number of processes that the end user will have to do.
Any suggestions would be appreciated!

Reply to this Message

Ed Bennett - 27 Mar 2005 21:50 GMT

> I am trying to use a macro in Publisher to open an Excel file that is
> a data source for a catalogue merge. Is this possible? I am not very
> familiar with visual basic. Right now I have exported some data from
> Filemaker into an Excel text file. I am using publisher's catalogue
> merge feature

I would suggest beginning by reading Andrew May's article on the subject,
here:
http://msdn.microsoft.com/office/understanding/publisher/articles/default.aspx?p
ull=/library/en-us/odc_pb2003_ta/html/odc_pb_catalogmergeoverview.asp

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Zack Barresse - 27 Apr 2005 06:10 GMT

Could you explain a little more what it is that you are trying to do with
Excel here? More details would be needed for further help.

Signature

Regards,
Zack Barresse, aka firefytr

>I am trying to use a macro in Publisher to open an Excel file that is a
>data
[quoted text clipped - 5 lines]
> do.
> Any suggestions would be appreciated!

Reply to this Message

Rate this thread: