Computer Support Forum

RS232 data

Question: RS232 data

Anyone know what software is best to use to enable me to view the data coming into my RS232 port from external scientific equipment?...ie an anemometer!....I need to view the raw data to check why I do not get the correct readings from the equipment and been told I should do a port scan...bit too techy for me!

Relevance 100%
Preferred Solution: RS232 data

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: RS232 data

9 more replies
Relevance 63.55%

I have a set of scales that outputs data on rs232. I need to read the data (weight in grams)multiply by a price per gram and output to a rs232 LCD display.Is there an easy way to do this. the scales constantly output and the price per gram has to be adjustable

Answer:RS232 data converter and output

Easy is a relative term.Most scales like that are used in some company or way that demands some software in order to be sold. Look at the makers web site for how they expect you to use the product. We still have many running a DOS app.1/3 of highway deaths are caused by drunks. The rest are by people who can't drive any better than a drunk.

2 more replies
Relevance 63.14%

My communication device communicates perfectly via RS232 and works fine on Windows XP. But when I upgraded to Windows 7 the data communication is too slow.

Answer:slow rs232 data communication on Windows7

Are the rs232c settings the same on both xp and w7?1/3 of highway deaths are caused by drunks. The rest are by people who can't drive any better than a drunk.

3 more replies
Relevance 63.14%

Hi;

We have a slitter scorer machine in which tools are placed via servo motors. Servo motor is controlled with servo drive and each servo drive is sent the values of a set of parameters to set a job. The main control system is DOS based which sends the values of parameters to all drives according to job. The data flowing is as MS DOS_RS232 port >>> RS232 to 485 converter >>> parallel connection to all servo Com ports. I want to monitor the data following from MS DOS to drives for which I have arranged another RS232 to 485 converter and connected a wire from TX+ terminal of 1st Comm module to the TX- terminal of 2nd Comm module. If I enable the hyper terminal, I see the data following but un-understandable format.

The format of data following from MSDOS PC to drives is like "7E-BF-02-04-3C-00" in ASCII format. So to read it I downloaded MS “PortMon” software which is used to monitor data following via RS232 port. I have windows XP and when I run the software, “Not Connected” is shown on the top bar. Please help how to make it “Connect” to capture the data. Or if anyone has any other idea to capture the data following, please assist.
 

Answer:How to capture the data following via RS232 in ASCII format.

If someone guide me about PortMon that how to make it "Connected" it would be enough for me. This time when i run PortMon, "Not Connected" displays at the top write corner.
 

1 more replies
Relevance 61.5%

HI,

I have a problem regarding rs232-usb converter... I'm using Toshiba Satellite series laptop.
The problem I faced is I can receive data from my microcontroller to VB but I can?t send data to microcontroller...

However, when I use the same VB code and same converter, I try at my friend laptop (other brand), it works...
May I know is there any other setting I need to set for my laptop??

Thanks.

Answer:Satellite A200 and RS232-USB converter - can’t send data to microcontroller

Hello

Do you have some problem with notebook functionality?
Are all ports working well?

Have you installed driver given on driver disk? If I understood it right you need this driver for virtual COM port creation.

Bu the way: which notebook model do you have?

3 more replies
Relevance 43.87%
Question: USB - RS232

On my old pc i used a belkin ups with their bulldog software. The ups connected to the pc via a serial cable and all worked very well.So I buys a new pc and realise that it doesn't have a serial port. So I get a USB- RS232 cable (serial connector one end to connect to the ups and a USB conector the other end).I installed the drivers from the disk that came wit the usb/serail cable but the ups is not detected. Interestingly if I go into device manager, after installing the driver, and expand the tree so that i can see the driver one minute its there the next the device manager tree closes then opens and the driver disappears then it re-appears!My operating system is win xp home sp2.

Answer:USB - RS232

TomGI've used usb-serial converters, not all with the same degree of success. In most cases however, a reboot seemed to cure most ails, and sometimes only with the usb converter connected before boot up. Not a lot offer, but might be worth a try if you haven't already...

10 more replies
Relevance 43.87%
Question: Rs232

I am planning on building a small form factor PC but it will need RS232. I don't know for sure if there will be room for an add on card for the RS232. Is there a usb to RS232? If so, will it work as good as an add on card?
 

Answer:Rs232

Usb to RS232 adapters/cables are common (on Ebay) and I assume they work well but I have never used one myself.
 

3 more replies
Relevance 43.87%
Question: RS232 on TV

RS232 on TV and Freeview Sat box. What is this serial port for?

Answer:RS232 on TV

Dunno about the TV. But my Humax Freeview STB has serial connection which can be used for uploading firmware upgrades from PC (after first downloading from Internet). Although the upgrades are available over the air, they are available sooner off the Internet.For this to work, one requires (for my box) what is known as a Null Modem Cable (and, of course, a serial connection on your PC). Cables avaialble on ebay, maplin etc.If you haven't got a serial connection on your PC, you can get a USB to serial adapter.It should all be described in your manual.Maybe the TV can take firmware upgrades in a similar way.

2 more replies
Relevance 43.46%
Question: Pavilion 550 RS232

Hi, I would like to buy a HP Pavilion 550-209nl Desktop, but I have a couple of issues:Is it possible to add a RS232 connection on it? I need it to connect some instruments at work.Is it possible to use with two screens? Cheers Ale

More replies
Relevance 43.46%

I am trying to make an application with C++Builder which communicates with a PIC16F877A which has a RS232 interface. Unfortunately my computer only has USB ports so I have bought a USB to RS232 converter cable.
Well I am a complete beginner to C++ Builder so really at this point I don't even know it will be possible to do this... Any help and advice would be really appreciated. ies
 

More replies
Relevance 43.46%
Question: RS232 Question

I am planning on building a small form factor PC but it will need RS232. I don't know for sure if there will be room for an add on card for the RS232. Is there a usb to RS232? If so, will it work as good as an add on card?
 

Answer:RS232 Question

Check out this link: TRENDnet USB to RS-232 . I do not personally own one, but I have used them at my job and they seem to work pretty well. You may have a driver issue, depending on the OS you will be using, but for the most part it works.
 

5 more replies
Relevance 43.46%
Question: wireless rs232

HelloDoes anyone know if it is possible to transfer data wirelessly via a rs232 connector on a Win95 laptop to another Pc with either Win95 through to Xp?Thank You!

Answer:wireless rs232

click here

4 more replies
Relevance 43.46%

Hi
i bought a cheap usb to rs232 cable of ebay for £2 with a driver disc.

When i connect usb to port the wizard takes over and asks to install disc but then it will not install .
Have downloaded different drivers but it still wont work,drivers are on desktop i think
thought cable was not working so ordered another but same problem.
Am i doing something wrong?
 

Answer:usb to rs232 problem?

Some manufacturers of converters like this require you to install the driver software before connecting the converter to the computer. I would suggest going into device manager and uninstalling the converter, restart the computer. Hopefully on the driver disk there is a "setup" or "install" utility that can be executed, run this install and after it is done connect the converter to the USB port on the computer and let the New Hardware Wizard do its thing. If this doesn't fix the problem try a different vendors converter.
 

1 more replies
Relevance 43.46%
Question: RS232 port

I have just bought new software for my laptop, it's for diagnostics on cars. The software has been configured to use a rs232 (db9) socket on the laptop to conect to the OBD2 on the car, the only thing i have on my laptop is USB's and the 25pin printer port. Is there a way around this?many thanks.

Answer:RS232 port

USB to Serial Port connector?

9 more replies
Relevance 43.46%
Question: RS232 connection

Not strictly a computing query but I just got a new LCD TV and it has an RS232 connection and so does my sky box. Can anyone tell me anything about it.

Answer:RS232 connection

It's generally used by factories and engineers for setting and controlling the user interface modules (menus) you see and use on the tv.

3 more replies
Relevance 43.46%

Hi allI am thinking of buying a new lap-top (nothing fancy) but I note that none seem to have an RS232 port any more.I MUST have RS232 because one use of the laptop would be in communicating with all sorts of strange devices that use RS232 (using all sorts of software).I know that USB to RS232 converters exist BUT now to the question:One piece of software I use is Hyperterminal and it "looks" for ports (eg RS232), but as far as I can tell, doesn't see USB (my son's laptop only has USB, and Hyperterminal only comes up with TCP, modem and COM4 (IIRC) which is the infra-red port). And all the other software (i.e. other than Hyperterminal) just seems to find COM1 and then works.Thus, does anyone know how all these RS232 bits of software could find the "port" via USB? Would the USB to RS232 converter cable have software that turns USB into COM1?Has anyone used stuff like Hyperterminal via USB?Thanks for any help.Skeletal

Answer:RS232 on new laptops

Is it a Basic Com port

10 more replies
Relevance 43.46%
Question: rs232 transmission

I am trying to connect windows xp com 1 to a wire edm machine rs232 port
machine receives in msdos. tried using hyper terminal. Program shows it sends but it is not received by the wire machine.
 

Answer:rs232 transmission

Hi, You might want to check and see if the machine receiving the data and the computer is set the same. (Data Bits,Parity, Protocol, Speed, Stop Bits, and Handshaking) They have to match on both or it will not work.
What DNC software are you using and what control is on the machine?
I might be able to help you better if I know that.
 

3 more replies
Relevance 43.46%

How do I determine if the USB port is actually getting data to/from the system's COM port?

Some info:
- I have Vista Home Premium
- I purchased a Generic USB to RS232 adapter (from China) based on a PL2303 chip.
- The driver that came with the adapter seems to have installed properly.
- I have RealTerm installed.
- I jumpered Tx to Rx plus other pins on the male DB9 connector.
- I sought help from Prolific (re PL2303), but found nothing helpful.

But I don't know how to look for data passing through the adapter. What I type on the keyboard does not show up on the RealTerm screen.
I've worked with RS232 for years, and know about the signal-type on the USB port.
But now I am stumped, and about to cut the vinyl covers of the adapter.

More replies
Relevance 43.46%
Question: rs232 transmission

I am trying to connect windows xp com 1 to a wire edm machine rs232 port
machine receives in msdos. tried using hyper terminal. Program shows it sends but it is not received by the wire machine.
 

More replies
Relevance 43.46%
Question: Wireless RS232

I need to extend a fiber optic connection one-half mile LOS. The fiber carries RS-232 data. Can anyone recommend a hardware solution?
 

Answer:Wireless RS232

While I haven't used them myself, this might help:
http://www.bb-elec.com/product.asp?sku=9PFLST&dept_id=101
 

1 more replies
Relevance 43.46%
Question: RS232 problem

This is for the really old hands...

Got this Seiko labelprinter on Com4 (hispeed pci serial card).
My mobo is Asus P5Q3 wifi-ap deluxe.
I am always on a hell of a ride before I get this to work, these are the options shown in device mgr.:
bps 9600...115200 (several tried)
databits 8
parity none
stop bits 1
flow control none/hardware/xon-xoff (think hardware was the control of choice when it at at last worked for prior W7 installs: Beta, RC, W7)
Com 4

Msg "printer communication error".
Only possible setting on the printer is the com port.

Now I can try for days changing this and that and maybe as before it starts to work "just like that", but it is annoying: I had a crash and reinstalled W7 Ultimate.

W7 gives me a choice of two universal drivers, V8 and V10, tried to change to V8 but that doesn't change anything.

Anyone?

Answer:RS232 problem

Normally you don't need to change settings on the port itself. I would look towards a driver issue here (check for drivers for the printer itself that are comparable with W7)

4 more replies
Relevance 43.46%

Hello,I've got a plotter (well, it's a vinyl cutter), which is serial and according to the manual the pin-outs are as follow.It looks to be as if they put '1' for RTS when really they meant '7'. However, that aside, is this a standard straight through cable because TX/RX are not crossed but I thought if it were straight through then 4/6 and 7/8 wouldn't be linked?I'd rather just buy a cable, but this layout is confusing me Thanks for any help in letting me know about this layout.

Answer:Help with 9 pin RS232 pins.

Early serial connector layouts  were defined by the computer maker.  If that was they way they did it, that was the way it worked. Standard layouts became standard later.The layout you show in the picture is not exceptional at all.Here is another almost the same.http://www.diyha.co.uk/electronics/comm1.htmlAnd with photoshttp://www.google.com/search?q=9+pin+serial&hl=en&client=firefox-a&hs=yHq&rls=org.mozilla:en-US:official&prmd=ivns&tbm=isch&tbo=u&source=univ&sa=X&ei=Sc7LTbDjKZO4sAObjqToBg&ved=0CDIQsAQ&biw=853&bih=372I like this one:

3 more replies
Relevance 43.46%

Hi guys

I purchased a HL USB RS232 (serial to USB adapter) and the drivers that came with it are not being detected by windows 7. Would anyone happen to have a link where i could find a working driver for Windows 7.

Thanks

Answer:HL USB RS232 driver

have you tried loading the drivers in compat mode ? Compatibility Mode

9 more replies
Relevance 43.46%
Question: No RS232 support

First, I appologize for this being so long-----I have a laptop I was given to use at work that is dual booted into Windows 98 and XP Professional. The Windows 98 is being used for the DOS architecture only. It is not a full operating system setup. I use this DOS for operating a data acquisition machine. However, this new laptop does not have an RS232 port for the DB9 adapter cable that is on the data machine. What I am trying to do is to use a USB conversion cable as this laptop has many USB ports. I know I need a USB driver for this to work. I went to the adapter's webpage and downloaded the driver for Win98 (as there is no driver support for DOS). Here is my dilemna: being that Win98 is not a full operating system, the driver will not load. Is there some way I can manually place the driver in config.sys and autoexec.bat in the DOS architecture. I have tried many configurations that did not work. Unfortunately this data system has to run in DOS only.

Answer:No RS232 support

No.It would have to be a driver written specifically for DOS to work properly.

8 more replies
Relevance 43.46%
Question: RS232 vs. Parallel

While working on a larger problem I found I was not quite sure of the port and cableling names. Is DB-25 RS232 the same as a Parallel port? Also, What is RS422 and RS485.

I know that DB-9 is RS232 and a serial port, so I assume that DB-25 RS232 is simiar to a serial port but I think I may be getting it mixed up with a standard Parallel port as well.

I had found one site but it was too technical for what I need to know. I just want to know an example of it's purpose and what type of connecter they use.

If someone could straighten me out on all this it would help me a lot.

[in case your wondering about the larger problem...it involves Punch Press machines, controls, and a BTR board. It seems most BTR's use a serial (DB9 RS232 connection) but ours uses what I am calling the parallel port]
 

Answer:RS232 vs. Parallel

6 more replies
Relevance 43.05%

I would like to reprogram a EEPROM, however it seems that my Serial Port does not provide power when I enter Windows XP. Under Linux, the JDM PIC programmer's LED lights up, however I need to use Ponyprog in Windows. I see there is power to the programmer just until I enter Windows. Any ideas? Thanks





T61p T7500, Quadro FX 570M, 4GB, 60GB Patriot Pyro, XP ProX61t Tablet, L7300 Centrino vPro, Windows 7 Home 64-bittpfancontrol installed on all systems

Answer:RS232 in Windows XP with PIC programmer

Hello mate, Try to see in the device manager if windows does not turn off the port to save energy.It's the only option I see for the moment. I try to look further if it's not the problem.





__________________________________________________________________________________Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information on it.ThinkPad T510 4313-CTO Windows 8 x64 - Intel Core i7-620M - NVIDIA NVS 3100M - 8GB RAM - 240GB SSD- Intel Centrino Ultimate-N 6300 - Gobi 2000.ThinkPad Helix 3697-CTO Windows 8.1 x64 - Intel Core i7-3667U - Intel HD Graphics 4000 - 8GB RAM- 256GB SSD - Intel Centrino Advanced-N 6205 - Ericsson C5621gw

5 more replies
Relevance 43.05%

I bought a hand held scanner which had a female 9 pin connector. My laptop only had a 15 pin rs232 connector. As I had spare usb ports I got a USB cable that had a male 9 pin attachment at one end. I also downloaded some drivers for HL-340. When the cable is attached it shows up as com4 usb-serial ch340 usb2.0-ser!. When I run the software associated with the scanner, a light on it flashes, but nothing else happens.Does anyone have any idea if I am using the combination of cables etc?

Answer:Rs232 to USB cable problem

If the port on the Laptop is an RS232 Serial port, are you sure it isn't 25-pin male? You should be able to get a 25-pin female to 9-pin male RS232 Serial Cable to connect the laptop and scanner directly. Have a look at this page click here

10 more replies
Relevance 43.05%

Hi, Ive purchased a USB To Rs232 cable to run on my laptop running Vista Premium 32 bit, but for some reason I cant find the correct drivers for it,the ones ive found are only for XP thats if there is one? if anybody has done this could you please let me know how it's done. Thanks

Answer:USB TO RS232 vista drivers

Make, model of lapy and the cable?

7 more replies
Relevance 43.05%

Hi, I need RS232 pinout of HP RP2 Retail System  2030 . How can i found it ? { RJ-50 Serial Ports (Power Configurable 5V/12V) } Could you please help me ? Best Regards, N A

More replies
Relevance 43.05%
Question: RS232 on M72e Tiny

Hello to All, On specifications M72e Tiny (MT - M 3267 - 5B1) it is said that on the motherboard there is a COM (RS232) port.If this is just how to activate and what is the connection of the latter? Thank you in advance for your answers.Cordially.

Answer:RS232 on M72e Tiny

Hello,Person for an answer?This becomes very urgent for our production.Thank you in advance.Cordially.

6 more replies
Relevance 43.05%
Question: RS232 serial port

Does the HP Probook 650 G1 Notebook PC come with a built in RS232 serial port. If not is it an option. If it is not avaiable is there a model with the RS232 port built in or available with an option.

More replies
Relevance 43.05%

I have an old trusty 2000VA UPS that has an RS232 communications port and I wonder if there's some way I can get Windows 7 64-bit to see the UPS via a USB converter cable. This UPS does not come with any Windows 7 driver or management software, Is buying a new UPS the only way forward if i want to protect my ASUS Republic of Gamers Core i7-3770K @ 4.6GHz machine?
 

Answer:UPS USB-to-RS232 Converter and Windows 7

The UPS doesn't have to be connected to the PC via USB or serial to protect it so you can use it as is.

Buy it will likely work for management with a USB to Serial adapter, Windows 7 has built in support for many APC UPS's out of the box. You may also find newer APC software for your model on the APX website.
 

3 more replies
Relevance 43.05%

I have used X10 successfully for many years and controlled my whole house via a CM11A controller. This controller connected to my PC through a serial port and could be easily programmed to change lights etc. Since the old PC died and I have bought a new one there is no serial socket on it. I got a cable adapter recently and installed the driver. After some jigging to get the device to be on COM2 (CM11A only allows 1 - 4) I still can't program the CM11A. The Activehome software fails its communication test to COM2. I downloaded a serial port monitor and it looks like bits are sending. Now I'm stuck! Any ideas out there?
 

Answer:USB to RS232 cable problems

Look in Properties for COM2 and check the baud rate, parity, number of bits, etc is configured properly. The manual I found says 4800 baud, no parity, 8 data bits, 1 stop bit.
 

2 more replies
Relevance 43.05%

I have the problem that my RS232 work not 100%under MS/DOS. In Windows XP the RS232 works fine.What can i do ?

[email protected]

Answer:Tecra Series S2 and RS232 under MS/DOS

Hi,

I think you need an adequate DOS driver for the RS232 port!

At http://newsletter.toshiba-tro.de/main/index.html you can ceck which hardware your Tecra S2 have an search a driver for it at the web!


TOK

1 more replies
Relevance 43.05%
Question: RS232 line drivers

Anyone had any experiance with these?I want to send (only) from a PC to some machines about 50 yards away. I need to do it using only one line driver at the PC. I have looked at the Patton website (model 1000) but it is not clear if I can use just one, for sending only, or MUST these things work only as pairs?

Answer:RS232 line drivers

click here for detailed information on the RS232.

2 more replies
Relevance 43.05%

Is there anyway to control Media Center via RS232?

Thanks

More replies
Relevance 43.05%

Hello

I need your help to find an USB adapter to connect to and Old Laptop that only have RS232 port.

I want to connect USB divices to the RS232 based Laptop

Thanks for your Help

Humberto Medina

Answer:Old Laptop with RS232 needs USB ports

pcmcia card to usb is ok

1 more replies
Relevance 43.05%

Does anybody know if a RS232 port is the same as a serial port?
 

Answer:RS232 the same as serial port?

Well, I think so. Just do some google image search on "Serial port" and see if that's you mean.
 

5 more replies
Relevance 43.05%

My new laptop doesn't have a Serial RS232 connection but I use one occassionally to download data to a Satellite Receiver.I've bought a RS232 to USB cable which was supplied without a driver. I've tried installing using XP's integrated drivers without success. Can anyone suggest where a suitable driver might be sourced? I've tried click here

Answer:USB to RS232 Serial cable

Possible source:click here(Drivers link, hopefully may work!)

2 more replies
Relevance 42.64%

Hello, so I bought cheap usb to rs232 cable off ebay and been trying to get it working. I tried installing many different drivers from internet and still windows is not recognizing my cable. I tried to copy drive file to system32\drivers, no luck.

Has anyone else had similar problem? Do I need to buy prober cable with driver cd included?

Thank you

Answer:Usb to serial rs232 no working drivers

You need a Prolific PL2303. Its the ONLY one I've found that will work with my wife's Singer Embroidery machine. It works on both Win 7 and Win 8.

Amazon.com: Plugable USB to RS-232 DB9 Serial Adapter (Prolific PL2303HX Rev D Chipset): Computers & Accessories

1 more replies
Relevance 42.64%

I can't get my usb to rs232 cable to install and vista keeps indexing the com port as it trys the next install. I have downloaded the driver, updated the driver, deleted the driver and reloaded the driver to no avail. Now it shows 26 com ports in use and tells me the device I am trying to install is trying to use a display name that is already in use. How do I clear this up so I can install this device?

More replies
Relevance 42.64%

is a RS232 port the same as my 9 pin com port?if I wanted to make software ROMs for my 8-bit bbc micro, what would kind of eprom programmer would I use?I'm a complete n00b in this field.

Answer:RS232 port & eprom Programmer

try an emulator to save the grief......Link:>http://www.emulator-zone.com/

2 more replies
Relevance 42.64%

Since installing SP3 to my Windows XP Pro system my RS232 serial port no longer works. I have a Hyperpen tablet that has an RS232 connection so it no longer functions. Is there a converter that I can attach to the male RS232 so I can connect via a USB port? I have seen a USB 2.0 to RSB (male) serial adapter dongle but that is of no use. I'd appreciate any suggestions towards resolving this.

Answer:RS232 serial port not working

Have you checked in Device Manager to see if it is working there , or if there any conflicts . It won't have just broken , it must be a software problem as it occurred as you loaded SP3 , it might just need reconfiguring , what does the tablet need in terms of port speed etc. , data bits , flow control etc. ? Ashley

7 more replies
Relevance 42.64%

I have a need for an RS232 port probably PCI, but I see such a wide diversity of prices. Which should I choose? Some have a UART and some do not. Do I need a UART? Thanks, Jim

P.S. I'll be using it with ham radio software called Ham Radio Deluxe (HRD) and a ham radio transceiver Yaesu FT-950

Answer:Adding an RS232 PCI port to my desktop

Check to see if you have a PCI slot. Some newer PC's only have PCIe slots and if they have a PCI slot it is a "bridged" slot to the PCIe bus and many PCI devices will not work or work properly on a bridged PCI slot.

I would check and see what others with that software are using.

(ex W5DVO/ZD8JES).

9 more replies
Relevance 42.64%

Hello All,

As a surveyor, I'm trying to slowly solve all the glitches on my new Windows 8.1 laptop.

1. Mouse

I often visit this NSW government site SIX Maps

When navigating the map, you use the mouse scroll wheel to zoom in or out and hold down the left mouse button to pan.

In my new windows 8.1 laptop, the scroll and pan functions won't work.

Iv'e tried 4 different mice and none of them work but they all work on my old XP laptop.

I've also tried 2 browsers (Chrome and IE)

I have also been in touch with the NSW goverment support team to no avail.

Looking in control panel, I couldn't recognise anything that would help.

Does anyone have any ideas?
2. USB to RS232 serial port cable replicator

This cable is used to download/upload information to the survey instrument. It worked fine on Windows XP, but will not work on Windows 8.1. It may be something to do with the port configuration.

Please note that the software is very old and I had to create a virtual XP machine using VMWARE to run it. (As well as some other obsolete software such as XTGOLD and Q.EXE! Any one remember these? I've yet to come across any file editing program to equal Q.EXE)

Hopefully someone will have some ideas otherwise I'll have to go back to the manufacturer and they'll charge more than I paid for the computer!!!

Thanks in advance for your help,

Michael

Answer:Problem with mouse and USB to RS232 cable

Well, I tried the link you provided and I was able to scroll using IE, Logitech Mouse, and Windows 8.1 Pro (64 bit). However, when I first accessed the site, it said that their site would work better with FireFox or Chrome. I have Chrome installed but did not try it.

USB to RS232, which end connects where? Does the USB end connect to the computer or the survey equipment? When running your XP, does it provide an error when you try to connect upload/download data? I would think that your VMWARE and XP will be able to handle everything, but you will need to play with port settings to have everything configured the way it was before. For example, my wife's computer is Windows 8.1 Pro, and I have her run VMWARE and Windows XP so she can use the embroidery module for her sewing machine. The one thing you have to do is to make sure that when you start the VM machine, you must tell the VM machine to use anything plugged into the USB ports to be used in the XP and not the Host machine.

Anyway, don't give up yet and keep poking around you'll find a solution.

5 more replies
Relevance 42.64%

i am using core 15 processor,dell n4110 laptop,, i tried to connect profolic usb to serial(rs232) cable. i tried in win7 professional and ultimate.in professional i installed but device is not working.. error statement is coming as "this device not srarted(code 10 err0r)"

Answer:code 10 error,usb to rs232 cable

Hi Ebin
Try to visit the following site:

USB to RS232 cable keep receiving a Code 10 message - Microsoft Answers

Good luck

1 more replies
Relevance 42.64%

I have purchased a usb to serial adapter but the drivers are not functional.

Every time I plug the cable inside my computer i get a USB device not recognized message. Under device management > Universal Serial Bus controllers > Unknown Device.

The drivers that i have is called "PL-2303 Driver Installer". Even after installing this driver, I still have no luck. I know it is possible to update the driver but the driver format would have to be in a .INF file. In this case the driver is a .exe file so i have no idea what to do.

Any help would be really greatly appreciated also the drivers are available @ http://www.prolific.com.tw/eng/downloads.asp?ID=31

If the device is functional and installed, it should be under the COM ports in device manager but like i said before it is not and is listed as "Unknown Device".
 

More replies
Relevance 42.64%

I have a CyberPower USB to RS232 adapter. From the research I have done this should create a Com Port in my "Device Manager" so that programs
are then able to use it. I have researched this specific device and there are apparently problems with how it works on WIndows 8.1 but I have not been able to find a solution. The driver for the device was installed by WIndows plug-and-play controls. It decided
that the "HID-compliant vendor-defined device" driver version 6.3.9600.16384 was appropriate, however there is no Com Port in the "Device Manager" and instead a "USB Input Device" appears corresponding to the adapter each time
it is plugged in. Under the "Devices and Printers" the "Unspecified" device "CPS RS232 USB Bridge for UPS" shows up. 


When I attempt to use drivers from a different source (the manufacturer of the USB to RS232 adapter), the plug-and-play ignore the new drivers and use the ones from above.



How can I get the Com Port created so that I can use the adapter properly?



Is there a way to circumvent the plug-and-play and use the driver from the manufacturer?


Thank you for your help.

Answer:CPS RS232 USB Bridge for UPS - not creating Com Port

Hi,
Regarding current situation, let?s try to manually install the driver by following these steps:

Device manager -> Right click the device and choose update driver -> Browser my computer for driver software -> Let me pick from a list of device driver? -> Have disk -> choose the driver manually to install.

Then let me know whether this device can work fine.
For further troubleshooting, please post back the image for descript more detailed about your issue.

For your reference:
SOLVED!!! cps rs232 usb bridge for ups driver UPDATE / DOWNLOAD
http://devicehappy.info/solved-cps-rs232-usb-bridge-for-ups-driver-update-download/usb-drivers/usb-driver-update-16/
Please Note: The?third-party website/product discussed here is manufactured by a company that is independent of Microsoft. We make no warranty, implied or otherwise, regarding this product's performance
or reliability.

Kate Li
TechNet Community Support

3 more replies
Relevance 42.64%

Dear Friends;
We have many software installed in Laptop having WXP for trouble shooting purpose at machines. Communication of many devices is done through RS232. Some time it happen that a we fail to communicate with a device while everything is ok because some other software has already captured RS232 port of Laptop and it is hard for me to find out which software has done that.
Yesterday, after making communication with a PC via two soft wares, I tried to hibernate the PC but it failed to Hibernate as Com port was busy/captured while all the programs were closed. Is there any way to know which program has captured the Com port?
 

Answer:How do we know which program captured RS232 port??

I have used Portmon with XP 32 bit: http://technet.microsoft.com/en-us/sysinternals/bb896644.aspx
I am not aware of an equivalent utility though for 64 bit XP.
 

2 more replies
Relevance 42.64%

wont print on rs232

Answer:tm-t88iii rs232 wont print

http://www.pos-printer.com/epson_tm...does it have Windows 7 drivers ?? I was under the impression Epson stopped support at XP ?

2 more replies
Relevance 42.64%

What is the maximum length that you can run a serial cable before having communication problems?
 

Answer:RS232/serial cable length

11 more replies
Relevance 42.64%

Here is the deal. Where I work we have a ticketmaster application that uses a seperate RS232 network. This means special lines that run to a special little ticketmaster box in my switch room. Needless to say it is a royal PITA when we have to move these computers connected to this special network.

So to fix this I was hoping there were some kind of RS232 to ether net adapters out there. I know they exist, but I think the solution I need is special. i need an Adapter on the PC side that talks to an adapter on the switch side. So basically the flow would go like this:


COM Port --> Convertor Box --> Ethernet --> Converter Box --> Com Port on Special Box

Anyone have any suggestions?
 

Answer:Piggy Back RS232 Over Ethernet

Is it realy Ethernet or justr cat5. (meaning is there going to be a ethernet switch in between?)
 

6 more replies
Relevance 42.64%

Hello Techguy
I have a USB to RS232 converter which came with a driver disk. I can load the driver in and everything seems to load OK. However, when I then plug in the converter, it can not find the driver.

What it seems to be looking for is a driver called "USB2.0-SER!". However, the device seems to be a Prolific chip device and I would have expected to see it looking for something like "PL2303" or similar. I searched the computer for a driver with this name but no luck.

I went to the Prolific website and downloaded their driver but that didn't work any better.

I know these devices work as I have seen them working on other computers. How do I get it going?
 

Answer:Solved: Driver problem for USB/RS232

6 more replies
Relevance 42.23%

Anyone know why my dell p1110 monitor turns off when I connect a RS232 <> TTL cable to the four pin header... I'm trying to use windas to fix the oh-so common brightness issue these monitors have and can't get very far without being able to connect the cable and view the screen at the same time. It doesn't fully turn off, but goes blank and the green light turns amber. Any suggestions are greatly appriciated!

More replies
Relevance 42.23%

On a box running Server 2003 the application needs to talk out a serial port to an OPTO-22 I/O system. The Optoscan program from the manufacturer works just fine. Our application (which has been used many times before successfully) is not sending or receiving message. It appears that another application has grabbed the port.

Does anyone know how to identify which program is controlling a serial port?

Thanks
 

Answer:Identify program controlling rs232 port

Portmon is a utility that should be able to tell you the name of the process that is accessing the port: http://www.microsoft.com/technet/sysinternals/processesandthreads/portmon.mspx

I use it at work as a RS-232/RS-422 protocol analyzer.
 

2 more replies
Relevance 42.23%

Hi - here's an idiot question for you. I need to know whether or not my laptop (Dell Inspiron 2200) has something called an RS232 serial port. I think it probably doesn't, as I couldn't find it mentioned in System Information. But I'd like to know for sure before I fork out £30 for a USB adapter, which is what I'm told I'll need if there is no RS232 port. It's needed for a programme called DesignaKnit 7 - details of which can be found at http://www.softbyte.co.uk/dk7.htm, if anyone is interested. So, can anyone tell me how to find out for certain whether or not I have this port? Thanks v much, Helen
 

Answer:Do I have an RS232 serial port for cable link?

You do not have an RS-232 port on that laptop. Note that the site in question has specific recommendations for the RS-232 <-> USB link device, and I'd pick one of their recommendations: http://www.softbyte.co.uk/usb_conv.htm
 

3 more replies
Relevance 42.23%

After several attempts at trying different driver versions, no drivers seem to load now.

These drivers are for a Prolific PL2303 USB to RS232 converter - although I did not buy the device from that company. The drivers used to install easily and I actually had one that partially worked.

At one point, I went to the Windows/System32 and manually deleted all the files and "packages" for those drivers. This likely screwed everything up and I don't know how to recover. I have the option of doing a full system recovery, but it will take days of work to arrive back at the current configuration.

After several attempts to install and uninstall all these drivers again, nothing seems to work. When I plug in the device, Vista looks for the driver in Windows Update and of course finds none. In Device Manager (DM), the annotation for the Port is Unknown device. When I try to manually install the driver through the DM, it fails. The code is sometimes 1 and other times 19.

System Info says I'm running Vista Home Premiun X86-based PC, but the sticker on the laptop says Athlon 64 X2 dual-core (Acer Aspire 4530).

Any fixes?

More replies
Relevance 42.23%

I have a machine that keeps a log of events and outputs them to a printer via an RS232 Port. I am trying to collect this information and input it directly into a datebase...Initially i would like to connect direct to a pc but eventually it may be helpful to pass the information by networkAny help or suggestions will gratefully received I have limited knowledge of how this all fits together but I'm not entirly backwards Cheers, Thanks for taking the time to read this

Answer:Connecting RS232 printer output directly to a PC

click here it may be what you are looking for?

2 more replies
Relevance 41.41%

oke this is the problem,i have a Philips BDL4221, i accidently locked the remote control and the onboard buttons, so i cant change the input or change anything on the tv, i tried to send some thing via 232analyzer but i have no idea what to do, the tv send me 2 messages back those are CTS turned on and DSR turned on, i found this in the user manual from the tv but i dont have any idea what to do with this:3.  Serial Interface Communication Protocol 3.1 General specifications 3.1.1  Protocol definition  Communication to the main monitor microprocessor is possible through the serial  port, which  support a communication protocol dedicated to BDS only. The protocol is specifically  designed to allow data communication in half duplex multi-point environments,  but  it can also be used for half duplex point-to-point RS-232 communication. 3.1.2 Communication characteristics A half duplex communication is implemented starting from the concept of a master-slave structure, where the monitor is supposed to be the slave. The first action is always taken by the master, which can be either a built-in PC-based video controller in a MASTER monitor or any external device (acting a server) interfaced to  the monitor. After sending a command or a request in the appropriate format (see section 3.2), the master receives form the slave an acknowledgement, which tells the transmitter whether the command is not valid (or not executable, anyway) or  ... Read more

Answer:sending ascii commands over serial rs232 to Philips TV

Looks all good. But for one thing. How do you do 57600 bps with a typical serial port?QuoteBaud rate  57600 bpsAre you sure?

9 more replies
Relevance 41.41%

After starting an application with the use of RS232 I get the message, that there is no RS232 available.The devicemanager shows an activated RS232.After deactivate and activate the RS232 - everything is ok and the RS232 is working.I use Windows 7. Any help would be appreciated.Thank you. Klaus

Answer:T60 with docking station 2504 - problem with RS232 to activate

hey Klaus_Johannes,curious, is the RS232 the serial port ? and does this happen to any devices connected to it or only for a certain device ?





WW Social MediaImportant Note: If you need help, post your question in the forum, and include your system type, model number and OS. Do not post your serial number.Did someone help you today? Press the star on the left to thank them with a Kudo!If you find a post helpful and it answers your question, please mark it as an "Accepted Solution"! Follow @LenovoForums on Twitter!Have you checked out the Community Knowledgebase yet?!How to send a private message? --> Check out this article.

1 more replies
Relevance 41.41%

I have Dell&#153; PowerConnect&#153; 3024 managed switch. I don't have the IP of the switch and I don't have RS232 cable. There is no reset button.

I don't know the IP so I can login from the web browser using Ethernet
 

Answer:Dell PowerConnect 3024 lost IP and RS232 cable

8 more replies
Relevance 41.41%

oke this is the problem,i have a Philips BDL4221, i accidently locked the remote control and the onboard buttons, so i cant change the input or change anything on the tv, i tried to send some thing via 232analyzer but i have no idea what to do, the tv send me 2 messages back those are CTS turned on and DSR turned on, i found this in the user manual from the tv but i dont have any idea what to do with this:3.  Serial Interface Communication Protocol 3.1 General specifications 3.1.1  Protocol definition  Communication to the main monitor microprocessor is possible through the serial  port, which  support a communication protocol dedicated to BDS only. The protocol is specifically  designed to allow data communication in half duplex multi-point environments,  but  it can also be used for half duplex point-to-point RS-232 communication. 3.1.2 Communication characteristics A half duplex communication is implemented starting from the concept of a master-slave structure, where the monitor is supposed to be the slave. The first action is always taken by the master, which can be either a built-in PC-based video controller in a MASTER monitor or any external device (acting a server) interfaced to  the monitor. After sending a command or a request in the appropriate format (see section 3.2), the master receives form the slave an acknowledgement, which tells the transmitter whether the command is not valid (or not executable, anyway) or  ... Read more

Answer:sending ascii commands over serial rs232 to Philips TV

Looks all good. But for one thing. How do you do 57600 bps with a typical serial port?QuoteBaud rate  57600 bpsAre you sure?

9 more replies
Relevance 41.41%

My M4600 Can not use USB & RS232 Port on Pro2X Docking Station.  This is new to me and in 100% mint condition as it had never been used and only turned on about 3 times.

I can use both DVI monitors attached to station, but can not see any of the USB or RS232 ports on my docking station.  My old M6600 can see them all just fine.

If the M4600 can not utilize the docking station ports, it is bye bye to the M4600.

Dave

More replies
Relevance 41.41%

I b ought one of these adapters off eBay so I could connect my GPS to my computer via USB, my old cable was the serial port. Anyhow, the seller told me it would work with Vista but she did not tell me it wouldn't work with Vista Premium. When I connect the device it tries to find the drivers but is unable to do so...does anyone know where I can get the right driver? The CD that came with the cable is worthless. Thanks
 

Answer:USB to RS232 Serial 9Pin DB9 Cable Adapter Driver

6 more replies
Relevance 41%

I am thinking to use one PCMCIA card as a RS232 serial port. The program that i need to use is running under DOS and needs two serial ports. My question is what i need to run the program and the serial port to be recognized by the system. I have a 4200 satellite pro series laptop.

Thank you

Answer:PCMCIA card as a RS232 serial port on Satellite Pro 4200

Why on earth should you want that ?
Your laptop has a serial port hasn't it ?

Well for serial ports are standard supported under Windows. In a Dos-box this should be no problem.

But pure Dos could be a problem.
I guess you also need DOS-drivers for your PCMCIA-card...

1 more replies
Relevance 41%

Hi,I'm considering switching out my "old" W500 with the new W520 machine. I now have serial port through my dockingstation, but i have not found any dockings for W520 with serial port out Is there a way to solve this issue, can I use the new W520  with my old W500 docking maybe?

Answer:W520 - I need Serial port (rs232/485) in the machine or docking station?

There are several USB -> RS232 solutions available from different suppliers. You could also use an ExpressCard adapter on the system itself.

4 more replies
Relevance 36.9%

Hi,
as you know the Equium M40X-189 P-M 730/XP has an RGP monitor port and does not have RS232 port.
I?m working with Auto-titration device which require RS232 port for connection!
Any idea of how i can connect my notebook to this device!

pls help
thanks
Omrankl

Answer:Equium M40X-189: How to connect RGB port to RS232 port?

sorri i meant RGB monitor Port!
omrankl

2 more replies
Relevance 36.9%

My data card supports EDGE and 3G data. I'm getting GPRS data speed though from system configuration, this is not possible as When any phone or modem supports EDGE then it will not go for GPRS. can anybody tell me whether my data card is showing appropriate data technology or not?

More replies
Relevance 33.62%

Hello, I've been struggling with getting a simple InfoPath 2007 form to work with a test MS Access 2007 database. I feel the best way to explain what I am doing is by giving you an example.

Background of scenario:

Lets say I am a distributor of gas cylinders. I have 100 different gas cylinders that I fill and send to customers. When they are done with the gas, they return the cylinders and I fill them back up. Each cylinder has specific data related to each: manufacturer, serial #, specific cylinder ID, and material of construction (carbon steel, stainless steel, etc). I have this data in my MS Access database, in an individual table called "CYLINDER_DATA". Every time I refill a cylinder, I need to record the date and measure the pressure and temperature (among other things) of the gas in the cylinder. This data (along with the specific "CYLINDER_DATA" at this date of measurement) must be added as a new record in a different table called "CYLINDER_MEASUREMENTS" in the same database.

What I would like to do:

So, I want to create an InfoPath form for operators to use whenever they need to perform measurements on a newly filled cylinder. So, I created an InfoPath form, that starts with a drop-down list box control that is populated with the 100 different cylinder IDs. A user would choose one of the "cylinder IDs" from the drop down list and then click "retrieve data". This would then populate the fields directly below:... Read more

More replies
Relevance 32.39%

I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.

151
183
2001

results = "151","183","2001"
 

Answer:Solved: Excel Column of data place in one cell with "data", "data" results

ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.

http://www.asap-utilities.com/

(edit: "entire column" -- do you mean full from top to bottom? )
 

2 more replies
Relevance 31.57%

Hi everyone, my software(data acquisition software) works well and saves data in the folder with full control permissions, but when I try to save my data in the restricted folder(only delete permission is denied) it displays an error access denied.
Is there any workaround to disable the delete option and keeping the normal functioning of software intact, as my intention is to allow the users to generate the data and restricting them from deleting the generated data
Thanks in advance

More replies
Relevance 31.57%

I have an android phone with data and an app called pdanet+. However, my phone isn't compatible with the wifi hotspot feature of the app. Therefore, I decided to use the Bluetooth internet feature of planet+, but it won't show up on my iPhone. Does anyone know what jailbreak tweak I can get to be able to make the connection between the phones?
 

Answer:How do I Bluetooth tether an android with data (using pdanet+) to an iPhone 4 w/o data (jail broken)

BTW, I've already tried ibluever from Cydia but it shuts down my wifi connection; the app needs wifi to activate.
 

1 more replies
Relevance 31.57%

Hello,

I have two problems:

1.
I have a lot of scanning data, all date and time stamped. All the scans show different status of shipped packages (all shipments have unique ID#, but there are multiple scans on route for all of them to track the packages). I want to find all the packages, for which there was "misdirected" scan, then for all of them, show the scan before. So, the end result would be all the scans that show for each package where it was misdirected (the terminal# of the scan before the misdirect scan).

2.
I want to automate this: run 5 queries every two hours between 8am and 10pm, copy and paste all results into Excel to specified areas (e.g. first query results to A1, second to A5000, third to A10000, etc. or onto different tabs), save as .csv to a specific folder, then send it as attachment to a given e-mail address. Even partial solution can be good.
I only know macros (somewhat), not as much VBA, so I tried that with the TransferSpreadsheet command, but can't get it work.

Any help is greatly appreciated.
 

Answer:Solved: ACCESS: Show second latest data and export data to excel from macro

14 more replies
Relevance 31.57%

Hi there,

I don't have enough experience in VBA excel or word, and would you mind helping for the following:
Q1
The below macro code add row below the last row. And Would you mind telling me what is the code that can add row for word document table between the last row and the row before the last?

ActiveDocument.Tables(1).Rows.Add

Q2:
My second question is related to export/import between two different programs or files ( Excel and word document)
Would you mind providing me the proper code for
Wordtable.copy
Workbook.xls - sheet1.past speical value
Suppose the word tables excel workbookD sheet 1 are as follow

Table 1 in word document
--------------------
Cell 11 - Cell 12
Cell 12 - Cell 22
--------------------
Table 2 in Word document
------------------------------------
Cell 11 - Cell 12 - Cell 13
Cell 21 - Cell 22 - Cell 23
------------------------------------

WorkbookD.xls – Sheet1
Rows Column
A B C D
1
2 wt1.Cell 11 WT2.Cell 11 WT2.Cell 12 WT2.Cell 13
3 WT2.Cell 21 WT2.Cell 22 WT2.Cell 23

How I write a macro to make the value or text in Cell 11. in word table 1 to be copied and past in Cell A2 in sheet1 of WorkbookD.xls
and the value or text of the range from Cell 11 to Cell23 of table 2 or word.doc to be copied and past in sheet1 of WorkbookD.xls from range B23 for n rows in table1 and table 2 of word.doc.

Thanks

Hamdy"
 

More replies
Relevance 31.57%

Hello,

I have a number of devices connected to my virgin router, via wireless and lan.

I was wondering if their was software that exists, that allows you to monitor the speed, traffic, and what kind of bandwidth each device is getting from the router, speed etc too .

Many thanks,

Stuart

Answer:software to monitor devies on network, data speeds, data usage ?

Since no one has replied. Here`s a google of programs.

Google

1 more replies
Relevance 31.57%

Excel 2003 SP3
Could anybody suggest a way, using whatever method you prefer to copy existing data to another tab, but have the data go transparent by 50%(or thereabouts, so you can just see it), but keep the headings normal font.
Thanks
 

Answer:Solved: Excel 2003 help to copy data to new tab and make data transparent

6 more replies
Relevance 31.57%

I just upgraded my Win10 X51 to the new creator version and now Dell Data Vault Data Collection Service has been running at 25+% for several hours.  How do I make this service stop overconsuming processor time?
Thanks.
Alienware X51 R3, Intel® Core™ i7-6700 (8MB Cache, up to 4.0GHz with Turbo Boost Technology) Includes Hyper-Threading.  Memory: 16GB (2x8GB) 2133MHz DDR4 Non-ECC

More replies
Relevance 31.57%

Hello - I am currently building an "Agent Journal" Database. This will be an area where supervisors can enter "Journal Entries" for their direct reports. The way it is currently setup is: The Supervisor form pops up. Supervisor selects their name from a dropdown, and select a command button. This opens another form with another dropdown that lists only the selected supervisors direct reports. Once the "direct report" name is selected, they will hit another command button that opens the "Journal Entry Form" On this form, there are text boxes for Supervisor and Agent. These fields are auto-populated based on the names selected on the previous 2 forms. There is also a combo box where they can select a "reason" from a dropdown menu, and a date picker so they can enter the date. The problem that i am having is: The data entered into the final form will not save to a table. I want to maintain the auto-populating of the Supervisor and Agent names when this form opens, and i want to have them select a command button to save all of the data on this form to a table. Can anyone help me with this????
 

More replies
Relevance 31.57%

First of all, what is background data and do you have to pay for it?
I never use my phone if it's not connect to wi-fi.
One day, I happened to be using the Data Sense app to see how much data I was using and I saw that the background data for the Internet was higher than the actual data used.
How is that possible? Please explain to me.
Thanks!

Answer:Why is the background data for my Internet App on my Nokia Lumia higher than actual data used?

Data Sense on my phone shows Cellular Data and Wi-Fi data. Not background data.
However Background data is typically data usage when you are not using the phone. E.g. a mail account checking for email. Or WhatsApp receiving a message.

4 more replies
Relevance 31.57%

I am an absolute begineer in MS Access. Will try to put my question as simply n clearly as possible.

I have designed a database to keep history of our company's projects. The 'Master Project History Table' contains fields including 'Project Ref', 'Project Title', 'Project Budget' and 'Project Year'. The users are expected to populate the table through 'Master Project HistoryForm'.

The key field is set as 'Project Ref'.

Some of the projects are combined with each other and to display this info, 'Master Project History Form' also has the fields 'Project Ref-1', 'Project Title-1', 'Project Budget-1' and 'Project Year-1'.

I am loking for a code for the ('On Update' event) that will fetch and display data in 'Project Title-1', 'Project Budget-1' and 'Project Year-1' fields when 'Project Ref-1' is updated. Please note that all this info is coming from the same 'Master Project History Table'.

My IT guys told me to use a code with variable for each field that goes something like this (to update Project Title-1 field):

Dim varX As Variant

varX = DLookup("[Project Title]" , "Master Project History Table" , "[Project Ref]=" & Forms![Master Project History Form]![Project Ref-1])

Me![Project Title-1] = varX

And then repeat for each other field by defining new vari... Read more

Answer:MS Access: Updating Data In One Field Should Update Data In All Relevant Fields

14 more replies
Relevance 31.57%

HELP PLEASE !!!!

I have attached a sample excel document
Basically each morning I receive a .txt file and I export it to excel.
I have a macro which deletes blank rows and therefore tidies the file up somewhat as the size is humungous!
There will be approximately 1000 brach i.d.'s on a daily basis within my file, but I have provided a few in the sample excel doc.
Within my attachment I have highlighted a specific branch and the information that comes with it. I only need part of the information (therefore many rows can be deleted within each branch i.d.

Please review the attached sample and keep in mind the following:

1. I need to keep the branch i.d. at the top of each section
2. I really only require the information that relates to "outstanding" and the few subsequent rows beneath

Can someone please assist??? I would be very appreciative
 

Answer:Need Help with wriitng Macro/code to rid unwanted data and retain specific data

I think this macro will work for you, though with dates involved, you never know.

BTW, I suggest that next time, Excel related threads should be started in the Business Applications section. You get help there sooner. Maybe better help as well.

Jimmy
 

1 more replies
Relevance 31.57%

Hiya

The Microsoft Data Analyzer design and create data cubes article sample files provides sample source data for creating data cubes from text files. Use this file in conjunction with the article Design and Create Data Cubes from Text Files.

http://office.microsoft.com/assistance/2002/articles/daCubePrinciples.aspx

http://office.microsoft.com/downloa...seID=43350&area=search&ordinal=12&redirect=no

Regards

eddie
 

More replies
Relevance 31.57%

Hi all,
Can someone help me with this issue in the Crystal Report

I am using Crystal Report 2011 and Oracle database.
My query is to output some columns in 2 different table(A,B).
After run query, there is 126,978 rows in the result.
In table A, there are 36 different types. The result shows same
in the Oracle Sql Development and Crystal Report (126,978 rows).
it also shows 36 different types in the details section. But when I right click
on that column, there is 23 different types and missing other 13 types.
I tried many ways but without successful (still missing).
Is there any problem with the software? Data missing hence I cannot create correct
dynamic parameter. If it does not show all 36 different type, then my query possibly
wrong, but it can show in the details section, then browse data option should show all 36 types right?
Do you have any idea to solve this?

Thanks in advance.
 

More replies
Relevance 31.57%

Hi everyone..

My external USb Wd mybook box has 1 tb Seagate Sata 3 and i use original Wd disc as W7 installed... in My PC Case as sata II

Today my old problem appears again as Corrupted disc...
I have Get Data Back NTFS (and i used before plenty of times for recovery, loss data or unwanted deletions) but..

This time im stuck.. Becouse the disk i try to recover includes 870 gb (about) used disk space (only audio files) only 50gb (about) empty space... Thats too big for me to recover to other disks.. i don't have enough spaces that my other disks can handle..

I have about 300 gb FREE disk space in several disks or partitions include My thinkpad SL510 Notebook..
---------
So my question is
wit keeping my lost data in corrupted disk first, can i take them slowly to this 300 gb spaces (i know i can) and after create somehow emty space (deleting those recovered 300 gb + 50 on corrupted disk) and
use that empty space for more recovery. ???? Or smilar solutions.. Becouse DISC PRICES IS HEAVY nowadays and really i'm out of budget with buying some
equipments upgrades..
----------
IS THERE ANY PRACTICALLY POSSIBLE SOLUTION even can take very long time..
Like creating slowly slowly some extra spaces (don't know how)

I know i look silly in situation becouse i know u should never write to same disc if you dont want to say goodbye to your files..

E-how happened (not necessary to read these part)

according my experiences Thats the mistakes... DOn't do those at the same tim... Read more

Answer:Data recovery problem, Can reach corrupted data but no external space.

Hi,

Before you write more data or attempt to read data from the drive through Windows, I would suggest using a Live CD like SysRescueCD to boot from and access the HDD.

2 more replies
Relevance 31.57%

Once disabled, Unable to enable restrict background data in data-sense in windows phone 8.1 lumia 720. Please help at the earliest as I've started getting out of memory error pop-up while on browser/apps and getting closed.
Regards,
Arjun

Answer:Unable to enable restrict background data in data-sense in windows phone 8.1 lumia 720

Try a Soft Reset. Hold the Volume Down + Power buttons until the phone vibrates and reboots (about 10 seconds).
If you need additional help or have more questions or details to share, please join the site so you can reply in this thread...

2 more replies
Relevance 31.57%

When i export my inventory from my DB into an excel file, my trailer brands are listed as they are in my DB (of course). But when i bulk upload them with XML feed to trailer inventory sites (HTW.com & HTT.com for our example here). My inventory is listed on their site, but it's not searchable because the brand search is a drop down menu on these sites.

Say i goto HTW.com and do a search for 'Blue Ribbon' trailers none of my blue ribbon trailers show up because all of mine are listed as 'BLUE RIBBON TRAILERS, LTD' and the site is searching for 'Blue Ribbon' and although they are the same trailer brand HTW.com does not see them.

What i'm looking for is maybe a Macro or even formula that once i tell it what site i'm working on, will go through my list and replace all my spellings with the proper ones for that site...

Attached is an XLS file with 3 columns, the first is my list as is from my DB, the other 2 columns are the proper spelling for each corresponding site...

Excel's find and replace feature is a VERY crude fix to this, but since it's so time consuming it's NOT a viable solution.

Any takers??

Slurpee? Zack? Anyone??
 

Answer:Solved: Excel -Macro or Formula? Replace my data with similar required data - sample

for the record, a complete solution would be GREAT, but not necessary...
I just need someone to point me in the right direction and maybe a small working sample of like 5 brands and i'll expand the list from there...

cheers
 

3 more replies
Relevance 31.57%

I am trying to capture data for below counters on windows server 2012R2  and i see no counter data getting logged. i can capture memory counters data without any issues.  any suggestions on what i can do


{\PowerShell Workflow(*)\PowerShell Remoting: # of connections closed-reopened, \PowerShell

                     Workflow(*)\PowerShell Remoting: #
of disposed connections, \PowerShell Workflow(*)\PowerShell Remoting: #
                     of created connections, \PowerShell
Workflow(*)\PowerShell Remoting: # of forced to wait requests in
                     queue...}
 

More replies
Relevance 31.57%

I need a spreadsheet that will match data in column A. Any time a specific work order number is entered/repeted in that column, and the numbers are entered under each shift, the totals will automatically subtract from the "orders to complete" . It will be a running total subtracting from the Orders to Complete column.wk order # Orders to Complete shift 1 shift 2 shift 3 shift 4 tot orders completed1234 200 10 10 20 30 70456 50 2 2 2 2 8987 500 10 0 0 0 10 1234 0 0 10 50 60987 20 20 20 20 80456 5 5 5 5 20

Answer:How to Match data, create formula&calculate if data matches

You didn't include any Column Letters or Row Numbers, so I am going to assume that your data looks like this:
A B C D E F
1 wk order # # of wk ordrs shift1 shift2 shift3 tot ordr cmplt
2 1234 200 10 10 20 40
3 456 100 2 2 2 6
4 987 550 20 50 41 111
5 456 20 10 40 70
6 987 10 10 10 30
7 1234 20 5 40 65Based on that table, enter this formula in G2 and drag it down:=B2-SUMIF($A$2:$A$7,A2,$F$2:$F$7)which should give you this:
A B C D E F G
1 wk order # # of wk ordrs shift1 shift2 shift3 tot ordr cmplt orders rem
2 1234 200 10 10 20 40 95
3 456 100 2 2 2 6 24
4 987 550 20 50 41 111 409
5 456 20 10 40 70
6 987 10 10 10 30
7 1234 20 5 40 65Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

18 more replies
Relevance 31.57%

I have an external data range importing data (Access DB via file DSN) into an Excel spreadsheet.
My problem is date/currency fields in Access do not format properly after refreshing. Most of the time the fields default to a general.

Any ideas?
 

Answer:External Data Range Imported into Excel-Data Format

10 more replies
Relevance 31.57%

Calendar on my nokia phone has deleted all past information and for this month it has shifted what was in there by one day (backwards)

Answer:Calendar problem - missing data and entered data moved

Originally Posted by Windows Central Question Calendar on my nokia phone has deleted all past information and for this month it has shifted what was in there by one day (backwards) Check your actual date / hour, maybe your phone got inconrrect ones

more replies
Relevance 31.57%

I have a spreadsheet that contains formulas. I want a macro that will copy the data only in that cell with the formula and paste only the data in another cell.

I have been scratching my head for a little bit on this one.

Thanks
 

Answer:Excel - copying data and pasting data in a formula cell

If I understand correctly, you can actually avoid using copy altogether.

Let's say you have the value 50 in A1 and the formula =A1*2 in A2. The following macro would copy A2 to D2:

Sub Macro1()
Selection.Copy
Range("D2").Select
ActiveSheet.Paste
End Sub

but because the formula uses relative references, the resultant formula (in D2) would be =D1*2.

So what you could do instead -- using a single command only -- is:

Range("D2").Value = Range("A2").Value

HTH,
bomb
 

3 more replies