PDA

View Full Version : Link Data to Excel update MP resets or can't place address



GEB
09-25-2005, 04:32 PM
Created a Hospital address dataset in excel. Column A is numbered 1-??? So it has a unique identifier. Link MP to excel. Several address not found. Manual matched record to area of map then moved record to correct address. PROBLEM > when updating Link to new data entered into excel MP wants to remap those records I manually placed. What do I need to do to fix this as it takes a long time fix over and over again.???

Wilfried
09-28-2005, 01:44 AM
Hi,

With programming this is easy done, but with the mappoint.exe I dont know. Can you not export the dataset again ?

GEB
09-28-2005, 05:21 PM
I work from a spreadsheet daily so the info changes all the time except for the address & Zip of the account. When I update the link to the data (excel spreadsheet) Mappoint will sometimes not map address that I have all ready manually mapped and or mapped and moved to the correct location. The problem is manually remapping those address again and again. Is there a fix or work around for this or is it built into Mappoint?

I am not a programmer, just a sales rep for a medical instrumentation company and want something simple to show accounts via Icon. Clicking on the Icon brings up all the info in the spreadsheet for that account. It works great, but info changes so updating the link is necessary. Having to manually remap accounts is not hard but its time consuming.

IS programming an option that will work with my application? If so, what kind of programming. Pleases elaborate.

Wilfried
10-01-2005, 04:30 AM
Hi,

Sure programming is an option with your application. Mappoint is accesable from most (if not all) programming languages. And in Excel you have the option to use VBA. For example you can make a form in VBA, put a mappoint component on it, and then the map is visible in Excel itself including programming. I cannot advice you in VBA but others can if you wants more information.