Hi to everyone!

I was just posting some question on Excel formula part. You could look it here:
http://www.excelforum.com/excel-form...is-closed.html

Some great guy send me a VB, works great but only if i use path in my computer, when i replace the path for https:// formula stop working.

I used this formula to make vlookup and "inderect" to closed workbooks.
EX: =VLOOKUP(B2;pull("'C:\Users\Windows 8\Desktop\["&$A$2&".xlsx]Sheet1'!a1:b26");2;FALSE) - A2 is the name of workbook
This works great but like i said when i replace the path with https:// stop working

I hope that someone will have a answer.

I will be also happy with some other option but not excel add in

Please find attached notepad with VB code
Pull.txt