Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL2K Qualifiers Mike Mertes Excel Programming 1 November 18th 04 06:51 PM
XL2K and Links Mike Mertes Excel Programming 0 November 18th 04 01:09 PM
HELP! XL2K to XP -what reference am I missing? Ed[_18_] Excel Programming 1 April 23rd 04 07:08 PM
Convert XL2K wkbk w/ macros to XL97? Ed[_9_] Excel Programming 1 February 13th 04 08:46 PM
Open XL2K without executing Macros Sean[_5_] Excel Programming 1 August 15th 03 01:00 PM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"