PDA

View Full Version : Getting file name from sharepoint



franklab
06-19-2009, 11:24 AM
Hi,

Im trying to get a file from a folder in a sharepoint.
file name will be like this: "powertools v1.1" version will change if new version is out.

my excel file need to validate if there is a new version on the sharepoint and copy it localy on the pc to make sure the user run the right version.
folder on sharepoint only have the lastest release of the tool.

here what i did so far but dont seam to be working:

Dim filename
Dim filepath
Dim wbworking
wbworking = ThisWorkbook.Name

filepath = "ht**tp://internalwebsite.com/personal/username/Shared Documents/Sales Tools/"
filename = Dir("ht**tp://internalwebsite.com/personal/username/Shared Documents/Sales Tools/powertools*.xls")


If filename > wbworking Then

--------------------

any suggestion.

Thanks