Hi All
Hope this isn't a FAQ - I've looked for several hours and can't find an
answer. I've written my first VB.NET app, a ~20 line console application
that opens up an Excel document, compares the number of the last line to the
number stored in a text document, and if they're different sends an email
..It's just a tool to alert me when someone has added a request to our log. I
wrote it as a standalone app because of the ungodly mess required to allow
me to put a macro inside an Excel sheet and not have to instruct all our
users to ignore the security warning - it requires digital signing and a
keyserver and someone who understands all that.
So, my little app runs great, emails me if it ffinds a difference, but my
machine is a notebook that goes home w/ me. So I want to run this on a
desktop machine here at work. And when I try that, I get the following error
message:
Unhandled Exception: System.Web.HttpException: Could not access
'CDO.Message' ob
ject. ---> System.Reflection.TargetInvocationException: Exception has been
throw
n by the target of an invocation. --->
System.Runtime.InteropServices.COMExcepti
on (0x80040220): The "SendUsing" configuration value is invalid.
--- End of inner exception stack trace ---
From googling around there seem to be many ways to get this error, but none
that I've found are unique to running on a machine different from the one
where the code is compiled. Any suggestions? Do I have to install something
on the target machine?
Thanks for any help!
Dennis 1 1116
I'm going to take a WAG...have you looked at permissions? Automated Excel
requires a valid login profile and the proper COM security settings. In this
blog post http://krgreenlee.blogspot.com/2006/...-excel_10.html in
a section under Administration Issues: User Identity I walk you through how
to make sure the COM security settings for Excel will allow automated Excel.
Good luck,
Kim
--
digipede - Many legs make light work.
Grid computing for the real world. http://www.digipede.net http://krgreenlee.blogspot.net
"Dennis Benjamin" wrote: Hi All
Hope this isn't a FAQ - I've looked for several hours and can't find an answer. I've written my first VB.NET app, a ~20 line console application that opens up an Excel document, compares the number of the last line to the number stored in a text document, and if they're different sends an email ..It's just a tool to alert me when someone has added a request to our log. I wrote it as a standalone app because of the ungodly mess required to allow me to put a macro inside an Excel sheet and not have to instruct all our users to ignore the security warning - it requires digital signing and a keyserver and someone who understands all that. So, my little app runs great, emails me if it ffinds a difference, but my machine is a notebook that goes home w/ me. So I want to run this on a desktop machine here at work. And when I try that, I get the following error message:
Unhandled Exception: System.Web.HttpException: Could not access 'CDO.Message' ob ject. ---> System.Reflection.TargetInvocationException: Exception has been throw n by the target of an invocation. ---> System.Runtime.InteropServices.COMExcepti on (0x80040220): The "SendUsing" configuration value is invalid.
--- End of inner exception stack trace ---
From googling around there seem to be many ways to get this error, but none that I've found are unique to running on a machine different from the one where the code is compiled. Any suggestions? Do I have to install something on the target machine?
Thanks for any help! Dennis This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alex |
last post by:
I wrote an asp program to send email. I set SMTP as 127.0.0.1 and it worked
well in Windows 2000 server but not in Windows 2000 Professional. What is
different between server and professional. My...
|
by: Deborah V. Gardner |
last post by:
I am trying to send email from Access 2000 using Eudora. The MAPI option
is set in Eudora to always be the MAPI server.
When I use the Send option on the File menu I receive an message...
|
by: Bonj |
last post by:
Right guys.
(I would like a solution to this in VB6 as this is what our needy app is
written in, but any solutions that involve .NET would be much appreciated
likewise as I could instantiate...
|
by: bivin |
last post by:
hai
i am requesting your technical support.
please help me.
i have been working with this for five days.
the problem is relating with the smtp.
i am trying to send an email from the asp.net...
|
by: HK |
last post by:
In VB.NET, I'm getting the exception "failure sending mail". I'm running VS
2005 on XP Home. This is a new install on a new PC. I've never had email
problems with VS 2003, and there I could...
|
by: Zeeway |
last post by:
hi,every one!
I have a question about sending emails.My codes works well over some smtp
servers,but doesn't over the others. My codes is listed belowed:
try
{
MailMessage mailObj = new...
|
by: Miro |
last post by:
VB 2003
at the end of the code, this works great.
bytCommand = Encoding.ASCII.GetBytes("testing hello send text")
udpClient.Send(bytCommand, bytCommand.Length)
and this recieves it
Dim...
|
by: Robert Dufour |
last post by:
Dim message As New MailMessage("mymail@mydomain.com", "mymail@mydomain.com",
"Test", "Test")
Dim emailClient As New SmtpClient("localhost")
emailClient.Send(message)
The IIS server is...
|
by: kohligagan2 |
last post by:
Hi,
I am working on a scenario . And scenario is I am trying to send an Email using my Lotus notes Client Id ( Lotus notes :- is used for messaging and sending mails work as a middleware)
I...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |