Ben,

Yes Win32APIs can be used in VBA. If you have experience of them you should
have no problems. If not, just post a question about the API you are
interested in, you are sure to get a reply.

As to RS232, there have been numerous posts on this topic. This link
http://tinyurl.com/mx0k will take you to hundreds of posts on the subject.

--

HTH

Bob Phillips

"Ben Zhu" wrote in message
...
I don't have a lot experience with the VB edit associated
with Excel/Word... Just wondering if I can invoke WinAPI
functions from the Excel macro?

If that is possible, then how? I have a small project
need use both lagacy RS232 port and excel sheet
functions. Really appreciated any leads / information.

Thanks a lot

Ben Zhu