Excel Vba Serial Port Mscomm32

Hi all, I have a cash drawer and and opener device connected to a USB port that is bridged to a COM16 serial port. According to the vendor I just need to send char(27)+char(53) down the serial port andit will open the cash drawer. They provide a MS Excel VBA sample which uses MScomm32.ocx and it works. But I have difficulties using that ocx file in PB 8. Is there someone here who can give me the required steps to implement and use that ocx in PB?

Even better would be a code example. Someone suggested to create a window, do insert-->control-->OLE and select the MScomm32.ocx file. So I did that and created a command button with the code to open the com port and send the string. But all I get is an error of something like 'invalid access of object property'. If someone could help me with this that would be great. Thanks for thinking about it. Hans ---== Posted via the PFCGuide Web Newsreader ==--- fisher, 1:55 น.

Hi Roland, Thanks for responding. Unfortunately this doesn't work for me. I put the MSCOMM32.ocx into c: windows system32, put an OLE control on a window (insert-->control-->ole, created a command button and for that a script with the commands you suggested.

Apr 16, 2014  Serial Port Communication in Excel (VBA) We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Char(27)+char(53) down the serial port andit will open the cash drawer. They provide a MS Excel VBA sample which uses MScomm32.ocx and it works.

But it comes back with 'invalid external function property for the first command. I did NOT declare any global functions. So the question is, did you and wich ones?

Regards Hans On 26 Dec 2007 08:27:18 -0800, in sybase.public.powerbuilder.ole-ocx-activex Hans, 8:31 น. Did you run regsvr32 on MSCOMM32.ocx?

I did this from a new app specifically for trying this out. Here are my steps: Open the New window and go to the 'PB Object' tab Choose Standard Visual and click OK Choose olecontrol and click OK Switch to the Insert Control tab Scroll down and select Microsoft Communications Control Click OK Save the object as u_mscomm32 Place the object on a window with the control name ole_1 'Hans' wrote in message news:4777c6b7$1@forums-1-dub. Hans, 9:31 น.

That is GREAT!!! Not sure what I did wrong when I tried it but it works!!! Only thing I can't do is read from the port. The connected device sends a status back wich is 'ESC + 60' if the drawer is open. In order to read I did this (after opening the port of course): blob rsdata string data rsdata = ole_1.object.input data = string (rsdata) The program runs over the statements and does not give any error message but the variabe is empty.

If you could help me also with this I would be infinitely grateful. On 31 Dec 2007 05:24:10 -0800, in sybase.public.powerbuilder.ole-ocx-activex Roland Smith [TeamSybase] wrote: >Did you run regsvr32 on MSCOMM32.ocx? > >I did this from a new app specifically for trying this out.

Here are my >steps: > >Open the New window and go to the 'PB Object' tab >Choose Standard Visual and click OK >Choose olecontrol and click OK >Switch to the Insert Control tab >Scroll down and select Microsoft Communications Control >Click OK >Save the object as u_mscomm32 >Place the object on a window with the control name ole_1 > > Roland Smith [TeamSybase] 3/1/2008, 5:00 น.

I have been tasked to copy excel workbook from windows xp machine running office 2003 to a windows 7 machine running office 2010. The workbook gets data from a serial port or winsock port. When opening the workbook after enabling the security dialog the VBA gets so locked up with missing libraries that you can't stop the VBA from running (compile error: method or data member not found). I can open the workbook on my machine because I have VB6 installed. Assassin creed iv black flag keygen generator. I would like to be able to stop the program from running and try to fix the references. On this same machine I opened a new excel spreadsheet, added macro, edited macro to get to underlying VBA. I then added a userform and tried adding the mscomm and winsock controls but these items don't appear in the list anymore.

Is there a new way to do this or did we lose features going from 2003 to 2010? So far I have found this answer 'The error value 0x8002801c means, Error accessing the OLE (Object Linking and Embedding) registry. You need to copy the MSCOMCT2.OCX file to c: windows sysWOW64 not c: windows system32. Run the command with elevated privileges, to do this, follow the steps below: i. Click on start and in the start search bar type CMD, right click on the command prompt icon in the programs area and then click on run as administrator. At the command prompt type regsvr32 wmnetmgr.dll and then press enter. ' I have the items registered and added to the references in the VBA but now I get a new feature from Microsoft 'the control could not be created because it is not properly licensed' when adding the control back to the form in VBA. Andrew tanenbaum sistemas operativos modernos pdf reader.