Microsoft Excel and Microsoft Publisher

[DebiEDS]

I need to automatically copy specific cells from Microsoft Excel into a graph
in Microsoft Publisher - How can I do this?

 

[Mary Sauer]

Select the cells, copy, paste into the Publisher table. Hold ctrl to select specific
cells in Excel.

 

[DebiEDS]

Thanks Mary,

Do you know of any macro type function that will enable me to do this
automatically or a way I can code anything to do this automatically either in
Publisher or Excel.
I know Excel has macros but don't think they will execute "externally"
outside of that software and I don't know if Publisher has any macro
capability.

I appreciate your suggestion, just wondered if there was another way?
Debi

 

[Mary Sauer]

We have a Publisher guy that will help. I'm sure he will answer your questions.

 

[Ed Bennett]

We have a Publisher guy that will help. I'm sure he will answer your
questions.

You can automate Excel from Publisher's VBA. All Excel commands are
available by calling an instance of Excel from Publisher's VBA. Publisher
has no macro recorder, so you will have to manually write your code, or hire
someone to do so for you.

Some tutorials on Publisher VBA can be found at
http://msdn.microsoft.com/office/understanding/publisher/default.aspx

Alt+F11 or Tools > Macros > Visual Basic Editor will bring up the VBE in
Publisher.

 

[Tom]

I moved my publisher files over to new computer when mother board died in old
one. I try to open my publisher files but it says it cannot open this
version. I right clik on my old files and its says version 2000.06
I have my 2000 program on new computer but still can't open these files?
HELP

 

[Mary Sauer]

Well Tom, it depends on where you live in Ohio. I suspect it is the reason for
your problem. I am in southern Ohio and I have no problems...

Have you installed a virus program, is it Norton?
How to use Office programs with the Norton AntiVirus Office plug-in
http://support.microsoft.com/kb/329820/en-us

What happens if you double-click a file?

I am assuming the files are on your hard drive.

How to troubleshoot a damaged publication in Publisher
http://support.microsoft.com/kb/198256/en-us

If all fails, send the files to me and I will see what I can do.

mary-sauer at columbus.rr.com

 

[Tom]

Mary I sent you an e-mail with a file attached