How do I send a string of text through serial port? Vba

Question

0.00/5 (No votes)

See more:

Excel-2016

E.g. I want to send this string of text "23423,10,20,Planning,2,1,Drop Off" from Sheets("Sheet1").Range("A1") through serial port.

What I have tried:

Currently, I'm using this and it managed to open the port but the result appeared as /xFF etc. 


COMPort = FreeFile
     Close #COMPort

    Open "COM5:9600,N,8,1" For Binary Access Read Write As #COMPort
    VarString$ = String$(10, " ")
    Put #COMPort, , VarString$
    Close #COMPort

Posted 1-Apr-20 20:42pm

Roboz

Updated 3-Apr-20 4:54am

v2

Add a Solution

Comments

Richard MacCutchan 2-Apr-20 4:28am

So what is the problem?

Roboz 2-Apr-20 4:29am

Hi, i'm new to VBA so i'm not sure how to send the string

CHill60 2-Apr-20 4:40am

But you have sent the string. Where is the result appearing?

Richard MacCutchan 2-Apr-20 5:11am

If you can send a single character then you just need to write a loop to send each character of the string.

CHill60 2-Apr-20 4:53am

What are you sending this string to? How are you determining that the "result" is /xFF? What are you communicating with via the serial port?

CHill60 3-Apr-20 9:29am

Hello? Is there anybody there?
Do you still need help with this? If so can you answer the queries please

[no name] 21-Jan-22 13:32pm

with above code cannot send AT COMMANDS Also just i could extrace Phone books By AT+CPBR=1,180

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2020-04-03T04:55:00

Solution 1

Take a look here: Perform Serial Port Communication from VB[^]
The usage of code is the same as in VBA.

See similar question on SO: What is the best way to access a serial port from VBA? - Stack Overflow[^]

Posted 3-Apr-20 4:55am

Maciej Los