CODEWITHSUNDEEP
vbaexcel
EJ_all_the_way
EJ_all_the_way

Reputation: 11

FileSystemDate VBA codes

Sub Test()
myURL = "http://sps.ap.emersonprocess.com/sg/pssops/svcops/APServicePortal/ChartTemplates/IBS-CCR-AP_Prod.xlsx"
Filename = "IBS-CCR-AP_Prod.xlsx"
myURL = Replace(myURL, "http:", "")
myURL = Replace(myURL, "/", "\")
MsgBox FileDateTime(myURL & Filename)

end Sub

Can you review my codes I just wanted to know the when "IBS-CCR-AP_Prod.xlsx" saved in a sharepoint drive, thats why I used FileDateTime but unfortunetly I had an error path not found. Thanks Big Regards

Upvotes: 0

Views: 145

Answers (1)

ignotus
ignotus

Reputation: 658

myURL already contains your filename, you needn't concatenate it, simply use 

MsgBox FileDateTime(myURL)

Upvotes: 2

Related Questions