I access the following code using a button on a form in Visual Studio, on running and selecting the button I get the following error message 'Runtime error 424: Object required', has anyone any clues as to what the problem maybe ??????
Private Sub Command1_Click()
sTo = "email@example.com"
sFrom = "firstname.lastname@example.org"
sSubject = "Insert here your subject text"
sTextBody = "Insert here your plain body text"
'Create the mail object
Set objMail = Server.CreateObject("CDO.Message")
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.