Is it possible to connect sharepoint data?

[jagannalla]

Hi,

- I have url of sharepoint data. Now, i want to connect to that url and retrive the data.

- Based on that data i want to generate reports

Is it possible to do this?

[#2]

heyy can you help me with the macro that you have written to derive data from sharepoint into excel and automate its refresh?

[#3]

Can you tell me how exactly you do it.  I tried and I got errors?