Hi, I am a computer science student, from Portugal, and i need help to Make
KML Files with Excel VBA.

In this part:

For Each cell In [Data2!A6.A50001]
pmName = cell.Offset(0, 2)
longitudeValue = cell.Offset(0, 1)
latitudeValue = cell.Offset(0, 0)

nembalagens2 = cell.Offset(0, 5)
totalcompart2 = cell.Offset(0, 6)

I need to change "For Each cell In [Data2!A6.A50001]" into something like
this: "For Each cell In ['C:\programs Files\Excel\NameOfBook.xlsm'
Data2!A6.A50001], because i want acess to another excel file from the file
where is the macro.

is it possible?

What is the sintax to do this?

Thanks!