Hi everybody,

I have a question. We have since last year MOSS 2007 as Portal for our
factory.
Many guys are still working with Excel 2007 and have done some macro to
gather information from different excel files.
Because we are moving everything step for step in Sharepoint we have the
problem that some time the excel file is not anymore an excel file but a list
in sharepoint.
So the question is :

Let say I have a Portal : http://myfactory
In that portal I have a list : http://myfactory/mylist
in myList have some column :
- "hours per Project" which is a value
- "Project number " which is a text
- and so on

I would like to get the info how can I make a macro in excel 2007 to reach
this file and import the value in a sheet or for a formule.
I do not want to import the all list ( which is pretty easy ) and I do not
want to write some value in this list ( i m doing it with InfoPath ). I just
want to be able to pick up the value that I need.

I will really be happy to get some help from you.

Best regards