troubleshooting Question

Create client socket and read from it, using nothing but Excel and VBA.

Avatar of arildj78
arildj78 asked on
Programming Languages-OtherVisual Basic ClassicMicrosoft Excel
9 Comments1 Solution10382 ViewsLast Modified:
WHAT I WANT:
I want one cell in an Excel spreadsheet to always have an updated GPS position.

CURRENT SITUATION:
GPS is connected to laptop via serial cable.
Via 3rd party software, the serial port is distributed as an TCP/IP port
When software makes a socket connection to the TCP/IP port, one text string will come every second containing current position.

HOW I THINK I WANT IT:
in VBA I plan to create a client socket, which can connect and read the GPS data. I'm able to handle the GPS data, but need help with creating the socket in VBA.

Arild

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros