visual studio - Finding what is different from VB(MSVisualStudio 2005) and VBA(Excel) -

-

I got the code online to do something like what I wanted to do, as always, I removed it in Visual Studio and That is not a problem.

There is a problem with it when I try to lock it in Excel, it ends up to work as I think VBA is a water version of VB (this article Based on reading :)

So, how did I know what went wrong between going between two programming environments?

To give a bit more detail: I have a program in program studio that presses a button when I send an email to me then I tried to lock it into Excel as macro, but That does not work.

EDIT: Notice of additional problem

I have Visual Studio Public Class here in Form 1 

  Private sub button 1_Click (System.Object , ByVal as the system. Sender). Button handles 1. Click the CDO_Mail_Small_Text () end sub sub CDO_Mail_Small_Text () object object in the form of Dim IConf as the string string DM FFDS in the form of iMsg = CreateObject ("CDO.Message") iConf = CreateObject ("CDO.Configuration"). IConf.Load (-1) 'CDO Source Flds with Default Flds = iConf.Fields ("Http: //schemas.microsoft.com/cdo/configuration/sendusing") = 2 .emem ("http://schemas.microsoft.com/cdo/configuration/smtpserver") _ = "morgan" .emem ( "Http: //schemas.microsoft.com/cdo/configuration/smtpserverport") = 25. Update () end with strobe = "Hi there" & amp; VbNewLine & amp; VbNewLine & amp; _ "This is 1 line" & amp; VbNewLine & amp; _ "This is 2 lines" & amp; VbNewLine & amp; _ "This is the 3rd row" & amp; VbNewLine & amp; _ "This line is 4" with iMsg Configuration = iConf = "Jeremiah.Tatongko @ PowerX.com.com" .cc = "" .bcc = "". "" Ron "" & rt; Something from ron @ Nl & gt; ".sebject =" Important Message ". TextBode = Strawberries. Ending With Closing Sub

And Class

Here I am running in Excel: 

  sub-button 1_Click () CDO_Mail_Small_Text end sub-sub CDO_Mail_Small_Text () Object object as Dimon IConf as active triggered string in form of IConf as string dim Flds object iMsg = CreateObject ("CDO.Message ") IConf = CreateObject (" CDO.Configuration ") iConf.Load (-1) Freeds with Flds = iConf.Fields. (" Http://schemas.microsoft.com/cdo/configuration/sendusing ") = 2. Item ("http: // Schemas.microsoft.com/cdo/config Uration / smtpserver ") _ =" morgan ".emem (" http://schemas.microsoft.com/cdo/configuration/smtpserverport ") = 25. Update ending strbody =" Hi there "& Amp; VbNewLine & VbNewLine & Amp; _ "This is 1 line" & amp; VbNewLine & amp;; "This is 2 lines" & amp; VbNewLine & amp;; "This is the 3rd line" & amp; VbNewLine & amp; _ "This line 4 Is "with iMsg.config configuration = iConf. =" Jeremiah Tatongko @ PowerX.com ".cc =" ".bcc =" "." "Ron" "& lt; nl & gt;" Subject = "Important Message" TextBode = Strawberry Finish with the end of the end

is not working: "run-time error '91': do not set object variables or block variables"

When I debug, I take me to the following line: "iMsg = CreateObject (" CDO.Message ")"

Cheers, -Jermia Tantongko

In VB6 / VBA you must use the sitemap while working with an object 

  set iMsg = CreateObject ("CDO.Message") set iConf = CreateObject ("CDO.Configuration")

Comments

Post a Comment

Popular posts from this blog

asp.net - Javascript/DOM Why is does my form not support submit()? -

-
This is my first time working with asp.net and javascript, so I do not know very good web resources, or Much about javascript debugging I have to find out that on line oFormObject.submit (); Microsoft JScript Runtime Error: Object does not support this property or method I am using the link to work as a button because I am terrible in aesthetics and I think That link will look more professional than a table of 50 buttons. I have read that this solution can cause problems with browsers due to pre-rendering of my links and many additional traffic and problems, but CSS gives me a button like a link, which has issues of alignment and difference seemed to. & lt ;! DOCTYPE HTML PUBLIC "- // W3C // DTD HTML 4.01 // N" "http://www.w3.org/TR/html4/strict.dtd"> & Lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Head & gt; & Lt; Link rel = "stylesheet" type = "text / css" href = "defect differen
Read more

sockets - Delphi: TTcpServer, connection reset when reading -

-
I am trying to implement one for Delphi, but there are some problems with communication. Fitnesse will start my process, and give me a portmember as a command line argument. Then I should make a socket on the port number given to me, and fitness will connect to that port I am using a TCPCP server for the job: < Pre> TcpServer1.LocalPort: = ParamStr (ParamCount); TcpServer1 Active: = true; On OnEXEPT () -Event, I send the protocol version to use as specified in the protocol. Process TForm1.TcpServer1Accept (From: TOBject; ClientSocket: TCustomIpClient); Var s: ansistring; Start clientSocket. Syndrome ('slim - v 0.0', # 10); SetLength (S, 6); ClientSketts Receavebook (S, 6); End; When I call ReceiveBuf (), the process ends, and fitness throws an exception: java.net.SocketException: connection Reset I have seen what sent and received. It shows that my code sends the protocol version, fitness sends back a message, and when I try to get this message
Read more

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -

-
I have a strange problem that I really do not know. In addition to developing a new ASP.NET site, I have to support the old "classic ASP" site. It is written in VBScript with a batch of JavaScript functions. Many of the JavaScript functions include 'files' Everything is fine on our production system (which security is controlled by another group - this is a military installation) Debugging them once did not work I). However, I have a fix for a vague bug that needs to be fully tested and some functions do not run under the "local" copy of the website that runs on my PC. For the record, I am running IIS 5.1 on XP. The problem is that some Javascript functions are running "OK" on the production server, but when they use it as a server, they are not defined on my PC what is happening that last Programmer, for some reason, has decided to put some functions in a series of files, which according to the observations, imitate the "need_once
Read more