Harlan Grove's Pull Function

[eholz1]

Hello Mr. Excel et al,

Mr. Excel (Bill Jelen) had a great podcast for Harlan Grove's pull function.
It worked great for Excel 2003.

I have not been able to get it to work in Excel 2007. Any ideas if VBA for Excel 2003
and VBA for Excel 2007 requires some sort of conversion?

Thanks for a great forum,

eholz1

 

[xenou]

Hi,

Normally vba works the same in 2007, although there are a few items that require attention, and of course some new features in 2007.

I'm not a user of this function - do you have more information on it? Perhaps we can take a closer look?

Regards,
Alex.

 

[eholz1]

Hello Alex,

Well for starters it is pretty cool. It will "pull" data from a closed workbook.
It works using a string for the workbook name, a worksheet in the workbook, and a range (or cell) on the worksheet. Here is a sample string for the vlookup function:

=VLOOKUP("M5-641",pull("'c:\test\[TAI_Matrix03.xls]MasterModified'!c3:c17"),1,0)

In this case I placed the Pullfunction.xla in my XLSTART folder for Excel 2003.

I will review the code, when I get less lazy, to see if I can find areas that are 2003 vba compatible as opposed to 2007. You can still find the bas module on line, do a search for "Harlan Grove's pull function"

Thanks,

eholz1

 

[xenou]

Hi,
Well, I cannot seem to download anything from this ftp site:
ftp://members.aol.com/hrlngrv/pull.zip

Not sure what's up here. I found source code published here under the GNU Public license version 2 or later:
http://groups.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd

Can you confirm this is the code you are using? I'll test it out at home (Excel 2007 / Windows XP).

If you post the same question on more than one site, be sure to make that clear in your posts - so that no one in one forum will be working on a solution where the answer has already been given on another site.

Alex

 

[eldertorrie]

Hello Everyone!

I'm in dire need of Pull! but I can't seem to get it to work on my excel sheet (I'm running Excel 2016) I'm using the code I found on this group on google by Harlan Grove. I'm using quite a simple formula: =VLOOKUP($O3;Pull($W3);3;FALSE) where O3 equals a date specification and W3 is the link to a closed workbook. Every time I click enter after entering the pull function excel just crashes and stops responding to everything.

I hope you can help.

Elder Torrie