PULL function for Excel 2000?

[travisc]

Anyone know where I can get a PULL function that works with newer Excel versions? Or maybe even remake the original PULL function so it works with newer versions?

Thanks,
Travis

 

[travisc]

VBAProject(2nd GL Rating.xls) --> Microsoft Excel Objects --> Modules --> pull

 

[Zack Barresse]

And that is the file you are calling it from?

 

[travisc]

yep... and I have it trying to call 2nd Shift Labor.xls

 

[Zack Barresse]

Do you have another routine with the same name? Check all modules and look in the right drop down box just above the code pane.

 

[travisc]

It's the only module I have...

 

[Zack Barresse]

Check this out: http://www.support.microsoft.com/kb/180277

See if that helps.

 

[travisc]

now that i've closed out of the file and reopened it... it accepts PULL... but it doesn't pull the information... file open or not.

 

[travisc]

=IF(ISNUMBER(VLOOKUP($A4,PULL("'\\BUNT5DCSRV1\storage\Butler\BM_MFG\Production Reports\2006 Production Reports\May 06''\Labor\[2nd Shift Labor.xls]"&DAY($U$2)&"'!$B$3:$C$86"),2,FALSE))=FALSE,"",VLOOKUP($A4,PULL("'\\BUNT5DCSRV1\storage\Butler\BM_MFG\Production Reports\2006 Production Reports\May 06''\Labor\[2nd Shift Labor.xls]"&DAY($U$2)&"'!$B$3:$C$86"),2,FALSE))

Doesn't work.

=IF(ISNUMBER(VLOOKUP($A4,INDIRECT("'\\BUNT5DCSRV1\storage\Butler\BM_MFG\Production Reports\2006 Production Reports\May 06''\Labor\[2nd Shift Labor.xls]"&DAY($U$2)&"'!$B$3:$C$86"),2,FALSE))=FALSE,"",VLOOKUP($A4,INDIRECT("'\\BUNT5DCSRV1\storage\Butler\BM_MFG\Production Reports\2006 Production Reports\May 06''\Labor\[2nd Shift Labor.xls]"&DAY($U$2)&"'!$B$3:$C$86"),2,FALSE))

Does, but not with the file closed.

 

[Zack Barresse]

With INDIRECT, yes, the file must be open. To use on a closed workbook you must use the INDIRECT.EXT function from Laurent Longre's morefunc.xll addin; although you've got about one good calc before it will error out.

Maybe you could try an alternative: http://vbaexpress.com/kb/getarticle.php?kb_id=286

They both use an old Excle4Macro method.

 

[travisc]

I tried INDIRECT.EXT also, but it doesn't work with a range of cells...