Hi Lori,
I also have some customers whose 2003 macros error out on 2000 machines. For
me it has always been an issue revolving around 2003 features not in 2000.
The only one that comes to mind immediately is the Workbooks.OpenText
Filename:=....
function. In 2003 you can add an argument at the end that tells Excel to
treat trailing minuses on values as negative numbers. Version 2000 does
recognize this argument. Also in this function the Origin:= part can contain
code after the = sign that will make the macro bomb in 2000.
By finding where the code errors out, I have been able to fix the macro so
it would be 2000 compatible.

--
Ken Hudson


"Lori Smith" wrote:

> Customers are reporting issues when sending documents created in Excel 2003
> to those with 2000. They are unable to use the macros. It is not an issue
> of security settings--all are set to medium. A user said they heard there
> was a way to create a macro in 2003 that is "saved as" 2000. Aside from
> issues with features in 2003 not in 2000, does anyone have any knowledge or
> experience with this issue?
>
> Thanks,
> Lori
>