On 20/11/2004, at 10:31 PM, J Philippe Chaperon wrote:
Dear WAMUG members,
I recently sent an Excel file, designed using Excel X (MS Office X),
which
contains some simple VBA scripts. The scripts work well on my Mac, but
it
did not on a PC running Win 98 and Excel 2000 when the following error
message was returned:
"Runtime error'1004' : Paste method of Worksheet class failed"
I have previously run various spreadsheets, designed on my Mac, and
which
contained VBA scripts without any problem on my work PC running Win
NT, and
also Win 2000.
Is this sort of error expected? My knowledge of VBA is very basic ....
Although I do not see any relevance to this problem, but just in case
it
does my computer is a G5 Dual 1.8mhz running OS X v10.3.6 and using
Office
X.
Many thanks for any ideas.
There can be problems when you make a file in Office X and then try to
view it in
an earlier version of office . Whether this is one of them I cannot
tell you.
?? What version of Excel was your office PC running and
what version was that file made with ?
Bob
Regards,
Philippe
-- The WA Macintosh User Group Mailing List --
Archives - <http://www.wamug.org.au/mailinglist/archives.shtml>
Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml>
Unsubscribe - <mailto:[EMAIL PROTECTED]>
WAMUG is powered by Stalker CommuniGatePro
