Thanks for the link. It's not quite what I was looking for, but came in
handy for someone else in my department.

"JLGWhiz" wrote:

Check out this site. It might answer your questions.

http://technet.microsoft.com/en-us/l.../cc288173.aspx

"PurpleMilk" wrote:

Thanks for your help, but it's not quite what I'm looking for.

I'm not creating/saving any file in the macro - it opens up each of
workbooks within a folder to see if there is a specific tab name, if yes, I
copy a specific row of data from the opened workbook into the file I launch
the macro from, then close the other file and go open the next.

The issue with sharepoint is it's url based not drive based and doesn't work
the same as in LAN folders.





"Joel" wrote:

Folder = ActiveWorkbook.Path
NewFile = "book1.xls"
ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile


"PurpleMilk" wrote:

This is a followup to a question I posted earlier.

I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but
this is the first time I'm working with URL's.

I need to run a macro in Sharepoint that accesses other files residing in
Sharepoint but can't figure out what the function/statement is to do this.

I can do this on desktop folders by using the following statements to simply
default the path to whichever folder the macro runs from (the macro is not
drive specific - can run anywhere):
ChDrive ActiveWorkbook.Path
ChDir ActiveWorkbook.Path

I would like to do similar in Sharepoint folder (again, the macro could
reside in different Sharepoint olders).

It was mentioned earlier for me to use the Sharepoint URL somehow (which I
know the current one, but not future ones), but I can't seem to find the
write statement to use.

Any suggestions?

NOTE: I would have appended this to earlier question, but had already closed
it off.

Thanks.