A macro for PasteSpecial?

T

The_waterbomber

Hi!
I looked a bit on the net and I found a lot of VB coding to create a paste
special macro in Excel but nothing in Publisher. Can it be done?

I need to paste an Excel table including the formating (colors).

Thank you all!
 
M

Mary Sauer

Insert, object, click from file, browse to the table, it should retain the
colors. Once it is inserted, double-click the object, you will be able to edit
it.
 
E

Ed Bennett

Mary Sauer said:
Insert, object, click from file, browse to the table, it should
retain the colors. Once it is inserted, double-click the object, you
will be able to edit it.
Click to expand...

We're in the Programming group and someone has actually posted a question
about macro writing (for once).

Manual clicking is not whas the OP asked for, unfortunately.

I am not aware of any way to automate Paste Special in Publisher,
unfortunately. If you find a way (which I hope you do), could you please
post it back to the group for the benefit of future group readers? Thanks.
 
T

The_waterbomber

Ed Bennett said:
We're in the Programming group and someone has actually posted a question
about macro writing (for once).

Manual clicking is not whas the OP asked for, unfortunately.

I am not aware of any way to automate Paste Special in Publisher,
unfortunately. If you find a way (which I hope you do), could you please
post it back to the group for the benefit of future group readers? Thanks.
Click to expand...
Well... Thanks anyway.

I'll certainly keep in touch if I ever find something...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Word macro that can call cells out of Excel for a find and replace 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Create a chart from a table in word thats dynamic 0
Macro to copy table of contents to a new doc 0
Outlook macro 0
"Compile error in table level validation expression " after format 0
Macro for Table of Contents 2

Top