Excel macros in XL2k Pro vs Std
 

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

Excel macros in XL2k Pro vs Std
 

Does he have the sendmail option installed?

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

--
__________________________________
HTH

Bob

"CLR" wrote in message
...
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

Excel macros in XL2k Pro vs Std
 

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" wrote:

Does he have the sendmail option installed?

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

--
__________________________________
HTH

Bob

"CLR" wrote in message
...
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

Excel macros in XL2k Pro vs Std
 

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

I would expect that to cause the separator differences.

--
__________________________________
HTH

Bob

"CLR" wrote in message
...
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" wrote:

Does he have the sendmail option installed?

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

--
__________________________________
HTH

Bob

"CLR" wrote in message
...
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

Excel macros in XL2k Pro vs Std
 

My Menu selections under File Send To, a
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


"Bob Phillips" wrote:

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

I would expect that to cause the separator differences.

--
__________________________________
HTH

Bob

"CLR" wrote in message
...
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" wrote:

Does he have the sendmail option installed?

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

--
__________________________________
HTH

Bob

"CLR" wrote in message
...
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