C
CLR
Hi All........
I have a macro that runs fine on my machine, but will not run on others.
There does not appear to be any machine-specific code involved. All the
other many macros in the same project run fine on all machines......but they
all fail (freeze) on the following line of this one macro:
..SendMail emadd, "Supplier Report Card"
Also of note, when I assign a path and filename to save the file to, my
machine separates the path and filename with a backslash, while the other
machines do not.
I can easily append the backslash into the path, but why should I have to
because my machine don't require it......and anyway, even if I do, the
othermachines still fail on the same .sendmail command.
I believe the problem is a setting in either Excel or Windows, but don't
know what. All machines are Dell, all run Windows XP, Excel 2000, and
LotusNotes 7.0, and it's very possible that they all are set up the same way,
and different from mine, as I have three versions of MSOffice on it.
I can provide the entire macro on request, but don't believe the problem is
really in the macro.
I have talked with our MIS Lotus Guru and he has no clue.
Any help will be much appreciated.
Vaya con Dios,
Chuck, CABGx3
I have a macro that runs fine on my machine, but will not run on others.
There does not appear to be any machine-specific code involved. All the
other many macros in the same project run fine on all machines......but they
all fail (freeze) on the following line of this one macro:
..SendMail emadd, "Supplier Report Card"
Also of note, when I assign a path and filename to save the file to, my
machine separates the path and filename with a backslash, while the other
machines do not.
I can easily append the backslash into the path, but why should I have to
because my machine don't require it......and anyway, even if I do, the
othermachines still fail on the same .sendmail command.
I believe the problem is a setting in either Excel or Windows, but don't
know what. All machines are Dell, all run Windows XP, Excel 2000, and
LotusNotes 7.0, and it's very possible that they all are set up the same way,
and different from mine, as I have three versions of MSOffice on it.
I can provide the entire macro on request, but don't believe the problem is
really in the macro.
I have talked with our MIS Lotus Guru and he has no clue.
Any help will be much appreciated.
Vaya con Dios,
Chuck, CABGx3