![]() ![]() Print #1, " " miuID " Owned by " ColName "" '4Īddress = Range("M" & i). Open "C:\Documents and Settings\eecoop\Desktop\10 day avg rssi Google kml\MorrisAveOpelikaMIUS.kml" For Output As #1Īddress = Range("M" & i).Text & ", Opelika, AL" REM Open "c:\Users\mwilson\Desktop\Test Google\Trash.txt" For Output As #1 REM Open File For Random As #1 ' "c:\Users\mwilson\Desktop\Trash.txt This is code I was handed to modify to get the data we need and therefore I don't know anything about how efficient it is compared to other methods. I am aware that the code is kind of ugly and needs to be cleaned up but my boss has told me not to bother since what I am doing won't be used in production and to focus more on getting the files he needs than making the code more readable. My boss is running Vista Business and he normally has this problem more than I do. ![]() I tried uninstalling/re-installing it, still get the same response. Tried to open Google Earth Pro on my desktop computer today, it will not open, comes up with the picture of the globe but then says it has to shut down. ![]() Would using a "template" to fill in the data for the kml work better? Created on I cannot open Google Earth Pro on my desktop. Here is a sample of my code and a sample of part of the kml file it creates.Īny idea about what I can do to solve these problems? If I try to just double click on the kml file without having done the process I just talked about, Google Earth becomes non-responsive. It then starts plotting just fine at that point usually. I then plot it, which causes this message:Īre you sure you want to reload this file, any unsaved edits will be lost? Most of the time to get the files to plot, I have to edit the kml with notepad, delete all but one of the points, plot that point, and then rerun an Excel macro to get the full file back. I also had a kml file I had to plot that is 937kb containing 2637 points. The kml files I am trying to load into Google Earth range from around 67kb for a file containing 177 points, to 454kb with 1172 points. Sometimes if I let it sit a while without touching it after it closes then it will open OK. Also, I can't just close Google Earth and open it back up when it becomes non-resposive because it still doesn't work. I am assuming this means Google Earth is storing it in a different format.Īt any rate, what should I do? I would really prefer to keep everything in Google Earth's "my places" since each file takes forever to load, but if I need to delete "my places" and start over I guess I'll have to do that. When I search my comp for "my places" the size of that file is only just under 400kb. I am assuming this problem is being caused by the fact that if I add up the total size of the kmls that I have saved to "my places" they are somewhere in the neighborhood of 3MB. Loading myplaces.kml, including enabled overlays Sometimes when I try to open Google Earth it just freezes while: I am having a problem with Google Earth freezing up both when I try to open it and when I try to plot KML files into it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |