RootsWeb.com Mailing Lists
Total: 1/1
    1. Re: [ROOTSWEB-HELP] Populating a Program with Data
    2. Hi Dennis, Since Excel has fields identified by row ID and column ID create a new column (call it map) and use concatenate to combine the constant you want plus the variables to build the html anchor statement. Once you build the statement for one cell in the first row you can replicate the cell. Now the main problem becomes how to replace the space with the + sign. You will need to play with your formula to see if you can make it work. Use the help function and look at commands Substitute Possible example to try =concatenate(<a href="http://maps.google.com/?a=, substitute(c2," ","+"), ",", substitute(d2," ","+"), ">,Map</a>) where c2 and d2 are Excel cells in row 2. I built the example to show the parts, but you should build it all as one character string. Good luck. Ron Morey >Denny, > >This may do what you want. It should be fairly easy to use the Kompozer html >editor to create a link URL like this: >http://maps.google.com/?q=N38+51.482,W077+41.111 (Antioch+Baptist) >Unfortunately google likes plus signs instead of spaces but copy and paste >should be pretty workable for creating the links. No javascript needed if >you don't want to embed the map in your page. > >Jim Rickenbacker >

    02/15/2010 06:58:57