Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
COM & LPT Communication - Excel VBA
Name: Alchard Date: November 19, 2004 at 16:11:19 Pacific OS: Windoes 98se CPU/Ram: VIA C3/256 Mb
Comment:
I have failed to find a comprehensible method of writing data to a serial and parallel port on a PC using Excel VBA. I wish to send control code (ESC/P2 codes) to an Epson dot matrix printer and send Hayes modem commands to a serial port.
Name: rayok Date: November 21, 2004 at 00:14:10 Pacific
Reply:
What you are trying to do is write directly to the device, what what windows generally and vb specifically wants you to do is write to the object. The last time I helped someone do this he had to get the program to open a dos debug session you can then write to devices via their address in memory. Search for dos debug on the Internet there is loads of stuff
Techy n Welsh
0
Response Number 2
Name: elric Date: November 21, 2004 at 04:32:34 Pacific
Reply:
G'day,
You can use VBA as you would VB6 to write to the printer or serial port using DLLs. There are a number of them out there, but I would strongly suggest that you visit this site: www.windmill.co.uk
Another good site, but not so specific to Excel is: www.lvr.com good luck, Elric
0
Response Number 3
Name: Grok Lobster Date: November 22, 2004 at 09:21:03 Pacific
Reply:
You can also use the Shell function to call a QBasic program that talks to the ports.
Summary: You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have one already. John Walkenbach and John Green both ...
Summary: I do not know your answer but I do know that you are using the worksheet property instead of a workbook property so your macro is limited to the worksheet. If you do not receive an acceptable answer t...
Summary: Hi All, I want to take a loan. Following are the input details: 1) I want to pay EMI max upto 5000 per month 2) Terms in months = 60 (5 years) 3) Interest rate = 15% reducing balance method I want to ...
0 
