Excel macros in XL2k Pro vs Std

[CLR]

Hi All.........
I have written a program in XL2k which works fine on my machine, and all
works fine on my User's machine, "except" for the sendmail procedure. His
machine fails on that line every time. In addiditon, his machine fails to
put the last backslash after the path, thereby appending the last
subdirectory to the front of the filename I assign in the macro to save the
file to for emailing. We both have Dell machines, set up by our MIS dept,
both on WinXP, "XL2k", and use Lotus Notes. We're trying to identify the
differences between our machines, so, My question is, "Do the different
types of XL2k (Std, Pro, etc), handle VBA macros in different ways, like the
difference between XL97 and XL2k"?

TIA
Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

Does he have the sendmail option installed?

I always find it best to test for a final pathseparator, better to be safe
than sorry.

 

[CLR]

Hi Bob.........
Thanks for the comeback.........
How can I tell if "he has the sendmail option installed"?

Would this condition cause the difference in the final pathseparator between
our machines?

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

I seem to recall it was an install option, if so then you can check by
looking at the menu options under File>Send To.

I would expect that to cause the separator differences.

 

[CLR]

My Menu selections under File > Send To, are:
Mail Recipient (As attachment)
Routing Recipient
Exchange Folder
Online meeting participient ...Grayed out

Don't make much sense to me, but I'll check his Monday when he comes back
and see if there is any difference.

Thanks
Vaya con Dios,
Chuck, CABGx3