# Reading Modbus into PLC

C
Thread Starter

#### Cedotal, Faron (FP)

I have a VAX that I can configure as a Modbus master. I am looking for software (driver/DLL/Active X control) that would let me use Modbus serial to get data directly into Excel without using Wonderware or some other MMI as intermediary. Any help appreciated.

Faron P. Cedotal
The Dow Chemical Co.
LA R&D - IS R&A
PO Box 400 B2504
LA Hwy 1
Plaquemine, LA 70765-0400
PH 225-353-8505
FAX 225-353-1973
Digital Pager 225-322-8505

A

#### Atul Shah

You can goto the site www.win-tech.com , they have various software for Modbus Stimulation.
For details of Modbus protocol please mail me back, I can send you the Word Document. This will be helpful if you can program a suitable driver using VB/VC++ or C language.

Atul Shah
Product Specialist - PLC
RW - AICC
ABB Ltd.
India

S

#### Shawn Summey

I have a Modbus ActiveX control that works rather well. It uses ModbusRTU, ASCII, or TCP/Modbus. I've used it in Microsoft Access a couple of times and it works great. I don't see why it wouldn't work in Excel. If you would like me to send it, e-mail me and I will attach it to the reply.

H

#### Hunter Farris

Look at the Modlink DDE software or even better and more reliable, use the OPC Factory Server that Modicon offers. Using VBA and Excel is not too complicated.

Hunter Farris

B

#### Bill Szuminski

There is a piece of "older" software called Modlink. It uses DDE linking and may still be available... if not try reviewing the OFS
Factory Server software in the modicon.com site. It's based on DCOM and Ethernet media.

G

#### Gillingham Household

Check out a product called DataWorX at www.iconics.com It provides OPC server to OPC Server bridging. e.g. Modbus OPC to DDE/ODBC OPC

B

#### Bob Welker

Don't know if they have anything that fits, but the Software Toolbox has a lot of drivers, et al. for darn near everything, and (if they don't) then I think they'll write things special order (special , too, I suppose). http://www.softwaretoolbox.com

V

#### Vithal Pai

Dear Mr. Shawn, Can you send me the Modbus active X control as an attachment for e-mail. We are developing a graphical application On PC. Thanking you, with best regards Vithal Pai

F

#### Finatzer

I am trying to get data of a power meter ( PM390 Northern Design ) into our visualisation made with VB 6 . I would like to try your OCX.
thanks

T

#### Timo Torma

I'm trying to work out a tiny scada for an online analyzer. I would like to try your active X. Could you send me a copy?

D

#### Daryl

I would be grateful if you can send me a copy of the Modbus OCX, as I'm developing a GUI for a Power Meter in VB.

D

#### Daryl

If anyone has source code for Modbus RTU protocol to a master please can you send me a copy.

email: [email protected]

Im not after the obvious OCX like automation-solutions. I want someone who has attempted writing a driver in pure VB code.

T

#### TrialProgrammer

Dear Sir,

I am not sure if I can get in touch with you at all as you posted your comment few years ago! but, I will try.

I am working on VBA and looking into real-time data sampling from various energy meters which have a serial communication port. It would be ideal if the data is directly stored in Access tables or an excel sheet. You mentioned in your posting that we are welcome to have a copy of the code if we email you.

I will be grateful to have a copy of the code if you still have it.

Thank you for your kind gesture.

Best wishes
TrialProgrammer - [email protected]

> I have a Modbus ActiveX control that works rather well. It uses ModbusRTU,
> ASCII, or TCP/Modbus. I've used it in Microsoft Access a couple of times and
> it works great. I don't see why it wouldn't work in Excel. If you would
> like me to send it, e-mail me and I will attach it to the reply.