VB problem

[scott_hanebutt]

I am trying to use Jack Dahlgren's "Export to Excel" code found at
http://masamiki.com/project/exporthierarchytoexcel.bas and am receiving an
error on the following line of code:

Set xlRow = xlRow.Offset(I, 0)

I have installed the Excel library. Has the library changed making the
offset command not work anymore?

Thanks,
Scott Hanebutt

 

[WD]

Scott -

You might want to take a look at your reference and ensure that it is the
correct version for the version of Excel that you are using. I believe 2003
is 11.0 for project and Excel.

You may also want to consider inculding the set ref command into your code.

HTH

 

[scott_hanebutt]

I am using 9.0 and my excel version is 2000. I have read that that is the
correct version.

Thanks,
Scott Hanebutt

 

[John]

Scott -

You might want to take a look at your reference and ensure that it is the
correct version for the version of Excel that you are using. I believe 2003
is 11.0 for project and Excel.

You may also want to consider inculding the set ref command into your code.

HTH

WD,
What exactly are you referring to when you say, "... the set ref command
...."? The only way I know to set references is via the "addfromfile" or
"addfromguid" and either of those must be set with an event macro prior
to attempting to run a macro where the reference is required. But I'm
always willing to learn new techniques.

John
Project MVP