Problem with modCOMM library and Bluethoot module

jmarar

New Member
Joined
Mar 30, 2024
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I am a retired electronic technician and I am creating a photovoltaic energy system for my use.
It works at 48v with 4 batteries in series. Each battery has its own charger, which I built, which receives power from its own panel.
With this I aim to always have the batteries equalized and the system works.
My problem begins when trying to send the charging data of these batteries to a PC, to record the evolution.
The data is collected by a uP and sent by Bluethoot with a BT-909 module.
These are received with another BT-909 module connected to a USB port of a PC, and an Excel sheet reads them.

To do this, I have used the modCOMM library implemented in an Excel sheet, which I found on the internet.

I'm not an expert in VBA, but I've gotten the system to work.
However, when I first try to connect the USB module to the Excel sheet, IT DOES NOT WORK and I get no response.
However, if the first connection was made through Coolterm and I sent AT to the BT909 module, it responds correctly, sending "OK". In this situation, without disconnecting the BT909 module from the port, I disconnect Coolterm and open and connect the Excel sheet, the transmissions are carried out correctly.

Could you give me some idea about what can happen in that first connection???
The truth is that I don't know where to go next and I don't know anyone who can help me...

I attach a pdf with screenshots of the process and the spreadsheet is half built, but with the communications completed.

Thanks and sorry for disturb

Joan Martí
 

Attachments

  • mail_1.jpg
    mail_1.jpg
    117.6 KB · Views: 22
  • mail_3.jpg
    mail_3.jpg
    68.8 KB · Views: 26
  • mail_2.jpg
    mail_2.jpg
    107.7 KB · Views: 25

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top