Copying a formated range of cells into publisher

B

brian

Hi all

I'm fairly new to VBA but have come across a problem that is driving me
mad

I'm trying to paste a range of formatted cells into publisher from
Excel.

I've tried AddOLEObject which sometimes works really well but more
often than not fails.

I have tried to change the cells into a picture in excel

Selection.CopyPicture
' ActiveSheet.PasteSpecial Format:="Picture (Enhanced
Metafile)", Link:=False _
, DisplayAsIcon:=False

but can't find a way to place the image onto the correct page in
publisher..

Can anyone help

Thanks in advance

Brian
 

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

copying all charts as enhanced metafiles 7
can't move chart to new worksheet 0
paste special picture from Excel 2007 to Publisher 2007 doesn't work 2
conditional format fails when copied 1
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Copy and Paste Charts as Picture in Different Workbook 12
Macros between two seprate windows (excel) 2
Copy Chart and PasteSpecial 2

Top