PPRuNe Forums - Help sought with VBA in Excel

PPRuNe Forums (https://www.pprune.org/)

- Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)

- - Help sought with VBA in Excel (https://www.pprune.org/computer-internet-issues-troubleshooting/176368-help-sought-vba-excel.html)

R4+Z	27th May 2005 08:57

Help sought with VBA in Excel

I was wondering if any of the knowledgeable folk here can help me with a Visual Basic for Applications problem I have.

I am trying to find out how to connect to a modem and send data and copy the responses recieved to excel cells. I have searched far and wide on the internet but can't seem to find anything so I thought if there is one place I will get an answer its here so over to you guys.

Thanks in advance

R4

ExGrunt

27th May 2005 10:42

I would second the above an suggest you try looking for:

mscomm32.ocx

Which is an add in which I think will do what you ask.

EG

rotorcraig

27th May 2005 18:38

Agree that you are unlikey to find a chunk of VBA code that does this.

You will need to use mscomm32.dll or some other add-in as ExGrunt suggests.

RC

R4+Z	31st May 2005 09:06

I found the answer and with it a most helpful site. worth checking out the other forums too.

Tek Tips

All times are GMT. The time now is 12:02.