I would like to load the contents of a file located in a sharepoint document
directory into a variable. I currently load it from a file system using a
filesystem object and getfile. This works great if the file is located in a
local share but error when I pass the path to the document in sharepoint (ex:
http://it.whatever.com/....). I'm using excel 2003 and sharepoint 2007.
Regards...

Have you tried mapping the SharePoint site?

--
HTH,
Barb Reinhardt



"Dave" wrote:

I would like to load the contents of a file located in a sharepoint document
directory into a variable. I currently load it from a file system using a
filesystem object and getfile. This works great if the file is located in a
local share but error when I pass the path to the document in sharepoint (ex:
http://it.whatever.com/....). I'm using excel 2003 and sharepoint 2007.
Regards...