In short..... Why not make this one long line?
If you do it as I've shown, your the code will be more readable and its easier to format the HTML. One liner is not easy to fix or debug. Why did you use If statements for the address?
I noticed that your drawing columns, contained 3 that should include address information so I wanted to make sure that your HTML was well formatted and did not include and empty lines bellow the "address information". In addition to this I also took this opportunity to show that you can include a bit of logic when retrieving a result. Is the vbNewLine important only within the script/code itself
No you it's not. If you want you can remove it. If you copy the text of one cell and place it inside notepad you will see that you will get new lines and in case you have any typo in your HTML its easier to fix. You don't happen to know if CSS works inside Google Earth, do you?
I believe so and the documentation confirms it. Just check https://developers.google.com/kml/documentation/kmlreference?csw=1#description Regards.
Stay connected: Linkedin >> http://www.linkedin.com/in/gustavopalminha Twitter >> http://twitter.com/gustavopalminha Other >> http://www.spatialmentor.com |