trouble with Jack's ExportToExcel VBA MAcro

[Buster]

When I run the ExportToExcel macro, I get an error when it hits this
subroutine;

Sub dwn(i As Integer)
Set xlRow = xlRow.Offset(1, 0)
End Sub

I have the excel object selected in VBE. Any IDeas? you can get the full
code at
http://masamiki.com/project/exporthierarchytoexcel.bas

 

[John]

When I run the ExportToExcel macro, I get an error when it hits this
subroutine;

Sub dwn(i As Integer)
Set xlRow = xlRow.Offset(1, 0)
End Sub

I have the excel object selected in VBE. Any IDeas? you can get the full
code at
http://masamiki.com/project/exporthierarchytoexcel.bas

Buster,
You didn't mention what the error is but I checked Jack's full macro and
there is an error in the code snippet you show above. In the line that
sets the row offset, the first variable is supposed to be "i" not "1".

If that doesn't solve the problem, tell us what error message you
receive.

Hope this helps.

John