Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

VB macro to get readings from digital scale connected via COM

Hi there,

I have a scale which is connected to the computer. I am using Hyperterminal to communicate with the sacale via COM#. The problem is that hyperterminal only takes 500 readings to be captured, while I need it to work for few days.

Is there anyway that VB macro can be developed in Excel inorder to take the readings directly to Excel?

Do you have any other solution?

Thank You
0
almotasam
Asked:
almotasam
  • 2
  • 2
1 Solution
 
PaulHewsCommented:
With Visual Basic 6 it would be possible.  With just an install of Office (without Visual Studio also installed) I don't think it's possible, because the MSComm component is not registered for developer use with it.  There might be third party comm components out there you could use.

One thing about hyperterminal is that you can set it to capture to a text file.  If you look at the Transfer menu, you'll see a "Capture Text" menu item that allows you to set a text file where the log entries will be stored.  Then it will capture the output of the window to the text file.  You could certainly process this text file after with VBA.
0
 
almotasamAuthor Commented:
Thanks,

So I need to buy VB6 to do so, I will try to do that. With Hyperterminal it will only capture what ever is in that window which is max 500 lines isn't it? I need a continuous capture so I can take thousands of readings.

Thanks
0
 
PaulHewsCommented:
If you go to Transfer menu > Capture Text, then you can set a text file and capture continuous data for as long as you wish.  
0
 
almotasamAuthor Commented:
OK, I will try that for the next 24 hrs and I will come back to you.

Thanks a lot
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now