| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 76779 | 2007-02-15 09:34:00 | Excel & GPS | nw3 (126) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 524960 | 2007-02-15 09:34:00 | Hi Is it possible to use VBA in Excel to 'communicate' with a USB wired GPS unit (bought at DSE)? If so, how? Or where can I find more info? I'm looking for code that captures the gps coordinates. Thanks. |
nw3 (126) | ||
| 524961 | 2007-02-15 17:40:00 | It's probably possible to export data from your GPS program to CSV, which could then be imported to Excel (some of the GPS software i know can do this) | Dannz (1668) | ||
| 524962 | 2007-02-16 18:43:00 | Thanks for your reply, but it was not what I was looking for. I need Excel to be capturing the info 'live' at the touch of a button or during an event. |
nw3 (126) | ||
| 524963 | 2007-02-16 20:39:00 | Thanks for your reply, but it was not what I was looking for. I need Excel to be capturing the info 'live' at the touch of a button or during an event.Then you need a GPS device that is capable of that, not Excel. I would assume if your GPS was capable of real-time transmission of coordinates, then it would likely have included software to make use of that. Depending on how you want this to work, tou may also need to be able to specify how often this 'real-time' data would be sent from the GPS, as if it were true real-time then you would be getting far more data than you could handle. Either data every so-many metres, or every so-many minutes, or every time you press a button to capture your location (not that useful if you're driving or riding a bike or similar). Mike. |
Mike (15) | ||
| 524964 | 2007-03-26 11:04:00 | Hi Mike The GPS unit can be found at www.dse.co.nz There is a very basic programme included on the CD, but it is very basic and does not allow saving of the coordinates. I am not really sure what triggers the GPS to send data to the computer, but it is nearly continuous (every second at least there are new coordinates being populated in the programme's window). The reason why I want Excel to do the capture is because I can play with VB. Imagine you are in a moving vehicle and want to capture the GPS coordinates at the press of a button on your laptop at that very instant. I guess all I want is for Excel to query the GPS unit at a particular time and get the coordinates then. Thanks. |
nw3 (126) | ||
| 1 | |||||