Please refer the below link

http://support.microsoft.com/kb/257819

If this post helps click Yes
---------------
Jacob Skaria


"Sverre" wrote:

I would like to create a VB-program to import data from other workbooks in
different places. It is not possibel by recording a VB, because you just have
to choose one fixed workbook.