Thread
:
Excel Macros in 2007
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Excel Macros in 2007
If desired, send your file to my address below along with this msg.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"JLara-MSN-WI" wrote in message
...
Thanks for your response Don.
The name exists, because I open the file in Excel 2003, run the same
macro,
and runs ok, but in Excel 2007 got the message.
"JLara-MSN-WI" wrote:
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett