Mapping to sharepoint drive

[PurpleMilk]

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.

 

[Joel]

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

 

[PurpleMilk]

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]

Excel will work the URL that start with \\drive\folder. You don't need c:\
drive letters.

 

[JLGWhiz]

Check out this site. It might answer your questions.

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

 

[PurpleMilk]

OK, would you be able to help me with the statement(s)? I don't use VBA
enough to easily figure this out.

For desktop version, I used ChDir and ChDrive to control the path and then
used Frombook = Dir(*.xls) when opening each of the workbooks in the path
(without the first 2 statements, the 2nd always points to D drive).

For sharepoint, I'm still lost on what function or statement I should be
using to achieve. And/or how to incorprate activeworkbook.path with it.

I set SPPath = activeworkbook.path, then I tried Frombook = Dir(SPPath &
".xls") but this doesn't work. lol, I have tons of test scenarios I'm trying
out that are laughable.

Hence why I need help from the forum.

 

[Barb Reinhardt]

It does work very much the same as LAN folders if you map the sharepoint
drive. Have you tried it?

 

[PurpleMilk]

I just haven't worked with coding URL stuff before and I guess I was making
it more difficult then it needs to be.

I just now was finally able to get a workbook to open.

Thanks for everyone's help.

 

[PurpleMilk]

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