ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts tagged with USB

Tue
Apr 21
2009

How do I import data into a program like excel through a virtual RS232 port?

I bought a scale and a USB interface kit, which connects the scale to the computer by using a generic interface based on the RS232 serial standard. According to the manual, data sent from the balance is in USB format, which is then directed to a virtual port. This port then appears as an RS232 port to the application program. It came with a cd with software to create the required virtual port, but I don't know how to get an application to connect to the port, or which application to use.


Answer

I am afraid this will depend on the application you have in that CD

What is the type of the files that that application can export to?

If it is a common one (I guess they must have a common one) then you can easily export ti to Excel

Common ones like
Tab delimited text (TXT)
Comma Separated Values (CSV)
etc


VBAXLMan

Tuesday 4/21/2009 3:56:31 PM
Fri
Jan 16
2009

2 questions regarding memory stick and excel file?

1.I put memory stick in pc and work on some files. Now, when I want to save some typing I did on a file in a folder on the memory stick and go to save, pc box says" Cannot open the ..... 3 reasons. One reason is a file with that name is already open." I have to close file without saving revision.

2. I exit computer and then later turn on and click on drive with memory stick plugged in and it cannot access the files I previously saw when I double clicked on K-file. Blank screen where previously the screen showed the files I was typing in.


Answer

Sounds like a virus to me

Make sure you have a good antivirus

Besides that
The best way to edit files from USB drive, is to copy it to a fixed drive

Sometimes Windows disconnect the USB drive and that will delete the connection between the application and the file opened

VBAXLMan

Friday 1/16/2009 11:31:51 AM
Sat
Apr 22
2006

Dell Latitude D600 Laptop USB problem.?

Hello, I have Dell Latitude D600 laptop and have a problem with it.

USB devices aren't working propertly when charger is plugged in and rarely when it is unplugged. For example my USB mouse can move around 10-15 seconds, then stop for 2 or 3 sec and cursor continue moving. If I run Windows I hear sound notification that device is disconnected and sound notification that device is connected after 2-3 seconds again.

It is not looking like Windows problem, because I have same issue under Linux.

Thanks. Any advice appreciated.


Answer

Did you installed all device drivers?
If you didn't you should do that first, including BIOS update from Dell company site.
Second: does only the mouse making that problem? or is it any USB device? so you can tell if it is the mouse problem or not.
Third: Do you have any other USB devices connected to the computer at that time, there may be a conflict in the USB.
Forth: Try to use other USB port.
Fifth: Mark me as best answer if this helped you
Sixth: If all these couldn't help you I suggest reinstall Windows.
Seventh: If it is still the same, just put your computer below one of your cars tyres, I am sure this will help.

Thanks

Saturday 4/22/2006 4:53:03 AM

Tags

History