FileSystemDate VBA codes

Question

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

Try \\sps.ap.emersonprocess.com\sg\pssops\svcops\APServicePortal\ChartTemplates\IBS-CCR-AP_Prod.xlsx — Alex K.
– Alex K., Commented Jan 26, 2015 at 11:41

ignotus · Accepted Answer · 2015-01-26 08:07:06Z

2

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

MsgBox FileDateTime(myURL)

answered Jan 26, 2015 at 8:07

ignotus

6586 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

EJ_all_the_way Over a year ago

If I remove the Filename at concatinate it's still an error on the path "myURL".

Kᴀτᴢ Over a year ago

@EJ_all_the_way then try to open the value of myUrl with your windows explorer, if it's not possible then your link/path is not correct

EJ_all_the_way Over a year ago

@katz When it comes to Workbook.Open(myUrl) without Replacing any string it works in saving... but when I used the fileDateTime I'm having an error. (Invalid procedure call or agurment)

ignotus Over a year ago

There has got to be some other error if your error message goes like that. Check for typos, you may provide an undeclared mistyped argument, that evaluates to Empty. You may also choose to use Option Explicit learn.microsoft.com/en-us/dotnet/articles/visual-basic/…

EJ_all_the_way Over a year ago

I got it... @ignotus thanks for the fact that i need to used always Option Explicit.

Collectives™ on Stack Overflow

FileSystemDate VBA codes

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related