From: [EMAIL PROTECTED] To: [email protected] Subject: Re: Problem with Excel - cross platform Date: Sun, 21 Nov 2004 07:55:28 +0800
>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 Something else to consider. Are the target PCs known to be good ones? In other words have you previously used these PCs to run your VBA scripts? I ask this as the function on the PCs can be disabled for security reasons, unless Im mistaking this with Macros, but I think they are the same. Not to sure where the settings are, sorry. Silly if you ask me, I think it would be like locking your gearstick so no wrong gears can be selected... while giving no option for an automatic gearbox. Good Luck Paul ...where is the sunscreen?
