Path not found (Error 76)

J

jtaylor13

New Member
Joined
Mar 4, 2008
Messages
16
A noob here.I get this error tryint orun a macro.

Open filepath For Output As #1
here is the excel i am using.
http://www.processtrends.com/pg_google_earth.htm


Sub generateKML()
' GenerateKML Macro
' Original Macro recorded 26/09/2006 by simon_a
' Modified by KOD Oct 4, 2007
' Set file path
Set filepath = [KML_Details!C2]
' Set document name
Set docName = [KML_Details!C3]

Open filepath For Output As #1
finish_rpt = "KML File Created" & vbCrLf
finish_rpt = finish_rpt & filepath & vbCrLf
finish_rpt = finish_rpt & "Use Notepad to examine file." & vbCrLf
finish_rpt = finish_rpt & "Make all edits to this workbook, not KML output file." & vbCrLf
finish_rpt = finish_rpt & "Use Google Earth to map locations."

'Write header to file
outputText = [KML_Details!C5] & docName & [KML_Details!C6]
Print #1, outputText

' Write Style id to head of KML file
style_text = [KML_Details!c15]
Print #1, style_text

' Get stydle id information
pt_style = [KML_Details!c16]

'Start to loop through stations
For Each cell In [Data!A6.A50001]
pmName = cell.Offset(0, 7)
longitudeValue = cell.Offset(0, 1)
latitudeValue = cell.Offset(0, 0)
pmDescription = cell.Offset(0, 8)
' Look for last row
If pmName = "" Then
Exit For
End If

'Create a placemark
outputText = [KML_Details!C8] & pmName & pt_style & [KML_Details!C9] & longitudeValue & ", " & latitudeValue & [KML_Details!C10] & pmDescription & [KML_Details!C11]

Print #1, outputText

Next

'Write footer to file
outputText = [KML_Details!C13]
Print #1, outputText
Close #1

MsgBox finish_rpt
End Sub
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Rich (BB code): 
Set filepath = [KML_Details!C2]
Set docName = [KML_Details!C3]
should be
Rich (BB code): 
filepath = [KML_Details!C2]
docName = [KML_Details!C3]
 
Upvote 0
It gives error 52.can i email it to you.here is my email.
email address removed by Moderator
(you don't want to post this on a Public Forum, as Spambots troll the internet for these)
 
Last edited by a moderator:
Upvote 0
I don't like the syntax of [] for objects...
try
Code: 
filepath = Sheets("KML_Details")Range("C2").Value
docName = Sheets("KML_Details").Range("C3").Value

If you still get error, I need to know what kind of values are in both cell.

It probably contains too many characters or invalid characters for the use of file name/path.
 
Last edited by a moderator:
Upvote 0
I am a noob to excel but can use it.here is were i got the file and what it does.
MapExcelData.XLS by ProcessTrends.Com

http://www.juiceanalytics.com/writing/excel-geocoding-tool-v2/

I want to take my excel file with address and convert to KML(google earth files) i use www.batchgeocoding.com but it has limits on how many i can do.
here is the excel cells i am using.

EXCEL HEADERS.

txt_parcel | txt_tax_bill_year | ADDRESS | City | state | amt_amount_due | amy_total_levy_due



<table style="border-collapse: collapse; width: 18375px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"><col style="width: 100pt;" width="134"><col style="width: 134pt;" width="179"><col style="width: 48pt;" width="64"><col style="width: 70pt;" width="94"><col style="width: 64pt;" width="85"><col style="width: 97pt;" width="129"><col style="width: 48pt;" span="218" width="64"><tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt; width: 48pt;" height="19" width="64">
</td> <td class="xl65" style="border-left: medium none; width: 100pt;" width="134">
</td> <td class="xl65" style="border-left: medium none; width: 134pt;" width="179">
</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">
</td> <td class="xl65" style="border-left: medium none; width: 70pt;" width="94">
</td> <td class="xl65" style="border-left: medium none; width: 64pt;" width="85">
</td> <td class="xl65" style="border-left: medium none; width: 97pt;" width="129">

</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> <td class="xl66" style="width: 48pt;" width="64">
</td> </tr></table>
<table style="border-collapse: collapse; width: 18326px; height: 33px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 14.4pt;" height="19"><td class="xl64" style="height: 14.4pt; width: 48pt;" height="19" width="64">
</td><td class="xl64" style="border-left: medium none; width: 100pt;" width="134">
</td><td class="xl64" style="border-left: medium none; width: 134pt;" width="179">
</td><td class="xl64" style="border-left: medium none; width: 54pt;" width="72">
</td><td class="xl64" style="border-left: medium none; width: 70pt;" width="94">
</td><td class="xl64" style="border-left: medium none; width: 64pt;" width="85">
</td><td class="xl64" style="border-left: medium none; width: 97pt;" width="129">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td><td class="xl65" style="width: 48pt;" width="64">
</td></tr><tr style="height: 14.4pt;" height="19"><td class="xl63" style="border-top: medium none; height: 14.4pt;" align="right" height="19">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 14.4pt;" height="19"><td class="xl63" style="border-top: medium none; height: 14.4pt;" align="right" height="19">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">
</td><td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr> </tbody></table>
 
Upvote 0
Your porblem, I think, is this part
Rich (BB code): 
Open filepath For Output As #1

So, we need to see what it is from
Rich (BB code): 
filepath = Sheets("KML_Details")Range("C2").Value
docName = Sheets("KML_Details").Range("C3").Value

If you show us what is actually written in KML_Details!C2, we mya be able to help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
Slow running macro
Replies
4
Views
272
wikus
W
K
  • Question Question
Extract links from Excel document and create .M3u8 files for each url link found in the sheet.
Replies
1
Views
798
KOKOSEK
KOKOSEK
U
  • Solved
MakeFDF Error: 5 Invalid procedure call or argument VBAProject
Replies
6
Views
588
6StringJazzer
6StringJazzer
M
  • Question Question
MkDir - "Path Not Found"
Replies
1
Views
3K
ukmikeb
U
S
  • Question Question
Save Each Row As A Text File - Including Text Formatting
Replies
6
Views
5K
shana
S

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top