Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parallel port control with Excel 2007 VB and Vista
I am trying to write a Excel 2007 VB program to control my parallel
port. I want to be able to turn individual pins off and on. I did this in the previous version of Excel and Win XP but I have not been able to find any driver/dll that works with Vista and Excel 2007. I have found inpout32.dll but it does not seem to work with Vista. There are a lot of sites saying it will but all I get is a error. I can not even register it. Not sure if it needs registered or not though. I have done all the admin rights and things to get it to work but it did not help. Does any one know of another free (no trial ware) driver or control that would work or how to get a vista compatible version of inpout32.dll to install and work? I would appreciate any help someone can give me. Thanks Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parallel port control with Excel 2007 VB and Vista
inpout32.dll is designed to work with a 32 bit operating system like XP.
vista is 64 bits so you have to make sure you are declaring your variables properly. did the inpout32.dll come with the vista operating system? then it should work provided you declare all the variables with the proper size. See this webpage http://msdn.microsoft.com/en-us/libr...acyhard_topic3 the most interesting part of the webpage is this section Unfortunately, for other parallel port devices you are left looking for the local driver and calling the Win32 API again. If you reference the IO.DLL library in your application (it is a COM library, so it will generate an Interop component), you can read and write to non-printer devices on the parallel port. Private Declare Sub PortWordOut Lib "IO.DLL" (ByVal Port As Integer, _ ByVal Data As Integer) PortWordOut(23, TextBox1.Text) --------------------------------------------------------------------------------- I'm wondering if the port number have changed. -------------------------------------------------------------------------------- "Scott" wrote: I am trying to write a Excel 2007 VB program to control my parallel port. I want to be able to turn individual pins off and on. I did this in the previous version of Excel and Win XP but I have not been able to find any driver/dll that works with Vista and Excel 2007. I have found inpout32.dll but it does not seem to work with Vista. There are a lot of sites saying it will but all I get is a error. I can not even register it. Not sure if it needs registered or not though. I have done all the admin rights and things to get it to work but it did not help. Does any one know of another free (no trial ware) driver or control that would work or how to get a vista compatible version of inpout32.dll to install and work? I would appreciate any help someone can give me. Thanks Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and Office 2007 stink (so does Vista) | Excel Discussion (Misc queries) | |||
Help using dll with excel 2007 and vista 64 | Excel Programming | |||
.NET RTD on Excel 2007 & Vista | Excel Worksheet Functions | |||
vista and excel 2007 | Excel Discussion (Misc queries) | |||
Vista bug (?) regarding Excel 2007 | Excel Programming |