Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

UNC or Last Modified Date via VBA?

  Asked By: Emma    Date: Mar 01    Category: Sharepoint    Views: 3135

All,

I have an Excel spreadsheet that uses VBA to look at the last modified date of a file on the network (uses CreateObject("Scripting.FileSystemObject") etc.) and then compares it to another file and updates it if necessary.

We have been migrated on to sharepoint (the files are saved their instead of the network) so now our Excel VBA does not work.

I need some way of determining the last modifed date of an file(.xls) on this URL that is 'readable' by Excel VBA?

http://ts/001/BGS_MI/Documents/Commercial%20Services%20Propositions%20Report/2013/

I have hunted high and low on the internet and forums and cannot find anything that works.

I am not a Sharepoint guru, I am just a user that is allowed to save files onto sharepoint, so I need the dummies guide please.

Thank you

Share: 

 

1 Answer Found

 
Didn't find what you were looking for? Find more on UNC or Last Modified Date via VBA? Or get search suggestion and latest updates.




Tagged: