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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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

K
  • Question
Extract links from Excel document and create .M3u8 files for each url link found in the sheet.
Replies
1
Views
461
KOKOSEK
KOKOSEK
U
  • Solved
MakeFDF Error: 5 Invalid procedure call or argument VBAProject
Replies
6
Views
460
6StringJazzer
6StringJazzer
M
  • Question
MkDir - "Path Not Found"
Replies
1
Views
3K
ukmikeb
U
S
  • Question
Save Each Row As A Text File - Including Text Formatting
Replies
6
Views
5K
shana
S
sharky12345
  • Question
Attach file to error reporting message
Replies
2
Views
357
sharky12345
sharky12345

Forum statistics

Threads
1,215,444
Messages
6,124,892
Members
449,194
Latest member
JayEggleton

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