Thread: Sending text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sunny[_4_] Sunny[_4_] is offline
external usenet poster
 
Posts: 3
Default Sending text

Hi,

I wrote a small test program that would communicate VBA
with an external microprocessor via the serial port. I'm
using MSComm. This code works fine when I send it out in
this fashion:

MSComm.Output = "123456"

However, when I use a variable for the output, I get an
error stating it's an invalid property value:

Dim v as string
v = "123456"
MSComm.Output = v

How is this different than what I did previously? I don't
know what to do. I tried using Str(v), but that doesn't
work either. Help! Thanks.