trouble with Jack's ExportToExcel VBA MAcro

J

John

Buster said:
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
Click to expand...

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
 
Top