Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA in Win 2K
I am often unable to do things in VBA in Win 2K that work fine in Win
98se. My current problem is in using SendMail. The single line of code: ThisWorkbook.Sendmail " works fine in Win 98 but when I run the same code in Win 2K (SP 3) I get a 1004 error, "Application or object defined error". Also, none of the routing functions work in 2K but work fine in 98. In Win 2K I am logged on as an administrator. Other than the different versions of Windows, everything else is basically the same on the two machines - Excel 2K (SR 3), Internet Explorer 6.2 is the browser, Outlook Express is the only email client and Outlook is not installed. Has anyone else had this problem and found a solution? Thanks, Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA in Win 2K
have you tried turning on the vba recorder and then FileSend ToRecipient
then looking at the code? " wrote: I am often unable to do things in VBA in Win 2K that work fine in Win 98se. My current problem is in using SendMail. The single line of code: ThisWorkbook.Sendmail " works fine in Win 98 but when I run the same code in Win 2K (SP 3) I get a 1004 error, "Application or object defined error". Also, none of the routing functions work in 2K but work fine in 98. In Win 2K I am logged on as an administrator. Other than the different versions of Windows, everything else is basically the same on the two machines - Excel 2K (SR 3), Internet Explorer 6.2 is the browser, Outlook Express is the only email client and Outlook is not installed. Has anyone else had this problem and found a solution? Thanks, Tony |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA in Win 2K
Thanks for the reply. Yes I did try recording it and nothing records
even though the email is sent. gocush wrote: have you tried turning on the vba recorder and then FileSend ToRecipient then looking at the code? " wrote: I am often unable to do things in VBA in Win 2K that work fine in Win 98se. My current problem is in using SendMail. The single line of code: ThisWorkbook.Sendmail " works fine in Win 98 but when I run the same code in Win 2K (SP 3) I get a 1004 error, "Application or object defined error". Also, none of the routing functions work in 2K but work fine in 98. In Win 2K I am logged on as an administrator. Other than the different versions of Windows, everything else is basically the same on the two machines - Excel 2K (SR 3), Internet Explorer 6.2 is the browser, Outlook Express is the only email client and Outlook is not installed. Has anyone else had this problem and found a solution? Thanks, Tony |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA in Win 2K
Are you able to Record any macros?
Are you SURE you clicked on the record button? When you push the Record Button do you see the Record Macro dialog? If not, either you haven't pushed the record button or you have a system failure. If it is showing, do you know how the find the recorded macro in the Visual Basic Editor: Alt+F11 And how to find your macros in the Project Explorer? "Just Me" wrote: Thanks for the reply. Yes I did try recording it and nothing records even though the email is sent. gocush wrote: have you tried turning on the vba recorder and then FileSend ToRecipient then looking at the code? " wrote: I am often unable to do things in VBA in Win 2K that work fine in Win 98se. My current problem is in using SendMail. The single line of code: ThisWorkbook.Sendmail " works fine in Win 98 but when I run the same code in Win 2K (SP 3) I get a 1004 error, "Application or object defined error". Also, none of the routing functions work in 2K but work fine in 98. In Win 2K I am logged on as an administrator. Other than the different versions of Windows, everything else is basically the same on the two machines - Excel 2K (SR 3), Internet Explorer 6.2 is the browser, Outlook Express is the only email client and Outlook is not installed. Has anyone else had this problem and found a solution? Thanks, Tony |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA in Win 2K
I found my problem and to help anyone else who may be having the same
problem, here is the solution: In the [Mail] section of the win.ini file the following line was missing, MAPIX=1 Once I added that line everything started working as it should. For more enlightenment see the Microsoft articles 290797 and 296396. Tony wrote: I am often unable to do things in VBA in Win 2K that work fine in Win 98se. My current problem is in using SendMail. The single line of code: ThisWorkbook.Sendmail " works fine in Win 98 but when I run the same code in Win 2K (SP 3) I get a 1004 error, "Application or object defined error". Also, none of the routing functions work in 2K but work fine in 98. In Win 2K I am logged on as an administrator. Other than the different versions of Windows, everything else is basically the same on the two machines - Excel 2K (SR 3), Internet Explorer 6.2 is the browser, Outlook Express is the only email client and Outlook is not installed. Has anyone else had this problem and found a solution? Thanks, Tony |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA in Win 2K
I found my problem and to help anyone else who may be having the same
problem, here is the solution: In the [Mail] section of the win.ini file the following line was missing, MAPIX=1 Once I added that line everything started working as it should. For more enlightenment see the Microsoft articles 290797 and 296396. Tony wrote: I am often unable to do things in VBA in Win 2K that work fine in Win 98se. My current problem is in using SendMail. The single line of code: ThisWorkbook.Sendmail " works fine in Win 98 but when I run the same code in Win 2K (SP 3) I get a 1004 error, "Application or object defined error". Also, none of the routing functions work in 2K but work fine in 98. In Win 2K I am logged on as an administrator. Other than the different versions of Windows, everything else is basically the same on the two machines - Excel 2K (SR 3), Internet Explorer 6.2 is the browser, Outlook Express is the only email client and Outlook is not installed. Has anyone else had this problem and found a solution? Thanks, Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|