Your guess was almost right, not in VB6 version, but in my .Net version I had a forgotten Dialing function which used the Modem and did not close MSComm correctly, therefore it impressed on System.IO.Ports.SerialPort as well. By closing MSComm in that function the probelm is solved...
Previously I had written an application with VB6 that works with COM Ports via MSCommLib.MSComm. It works properly with COM1 as RS232 port and runs its codes perfectly. Lately I'm writing another application with VB.Net 2010 which needs to deal with RS232 port. Therefore I'm...
I've read articles about; "Sending and receiving data from RS232 or USB ports" or, "Using vb.net to switch on/off electrical devices", but conversely in my case I want to just using a simple electrical switch to do something in my vb.net application (via RS232 or USB port). For...
Thank you anyway John for WMI Code Creator, it was useful.
But in my case, the problem was a bunch of permissions in Group Policy, WMI Policy, Windows Firewall, DCOM port range configuration and some Windows services that must run for remote computer mananging. After error: "Cannot create...
Surely it's an extremely useful tool. It generated codes below.
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_OperatingSystem",,48)
For Each objItem in colItems
I'm not sure this post belongs to this section, if so I would apologize.
I'm trying to get the computer description by computer name. The problem is; I get this error "Cannot create ActiveX component" when the following codes run, while the variable ComputerName sets to another...
Thank you John, your links led me to this;
If (WebBrowser1.Document IsNot Nothing) Then
For Each doc As HtmlDocument In WebBrowser1.Document.All
doc.RightToLeft = True
WebBrowser1.Document.RightToLeft = True
Note that these codes must be written in...
Thank you for sample, seems to be useful. So you had tested it before. Doesn't it solve your problem in Excel?
I read about Perl the night I was searching for Printing Excel documents LOL. I'm just downloading ActivePerl and will tell the result whenever I learnd how it worls. Has it any...
Obviously being newbie in forums does not mean being newbie in software developing, although all of us are always newbie in science, sepcially computer science, for it's an endless ocean.
Anyways, no dobt xPortTools should be a worthwhile tool as you described. I will research about that. But...
Totally what's the usage of Excel in your applications?
I usually use it to produce predefined invoices, reports and similar things, and now I'm going to replace ReportViewer or Crystal Report.
What's your usage of Excel? Couldn't you replace it with some thing else?
you can search and study about Excel Automation in Vb.Net in the following links.
How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays
How to automate Microsoft Excel from Visual Basic .NET
Automating MS Excel Using Visual Studio .NET...
Well it completely works fine... :rugby:
Dim m_sConn As String = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=C:\MyFile.Xlsx;Extended Properties=""Excel 12.0;HDR=YES"""
Dim conn As New System.Data.OleDb.OleDbConnection(m_sConn.Replace("HDR=YES", "HDR=NO"))
' NOTE: The connection string...
Thank you Rob and thanks JohnH.
I guessed, it's rational when we use GetObject("", "Excel.Application") therefore there must be an Excel Application. But still I'm hopeful LOL. Where there's a will there's a way.:apple:
And Rob I followed your link and it was somehow useful or atleast thought...
First of all I would apologise if this topic does not belong to this section of forum, for indeed I did not find its proper place. It's about Excel programming in VB.Net language.
Anyway, perhaps you know that there is a set of components named "Access 2010 Database Engine"...