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.