View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JLara-MSN-WI JLara-MSN-WI is offline
external usenet poster
 
Posts: 1
Default Excel Macros in 2007

In Excel 2003, my macro runs ok, but in Excel 2007 got the message:
Run Time error '1004':
Paste method of workshett class failed

This happens when the macro runs at:
Application.Goto Reference:="Mes_DosOnce"
ActiveSheet.Paste

My workaround is to run the macro in an Excel 2003 instance, but i need to
copy the file between pc's.

How this issue Can be solved?