Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
Public Function GetFileProperty(myFile As String, myType As String) As String 'This creates an instance of the MS Scripting Runtime FileSystemObject class Set oFS = CreateObject("Scripting.FileSystemObject") Select Case UCase(Trim(myFile)) Case "CREATED" GetFileProperty = oFS.GetFile(myFile).DateCreated Case "MODIFIED" GetFileProperty = oFS.GetFile(myFile).DateLastModified Case "ACCESSED" GetFileProperty = oFS.GetFile(myFile).DateLastAccessed Case "SIZE" GetFileProperty = oFS.GetFile(myFile).Size Case Else GetFileProperty = "txt" End Select End Function Public Sub SperiamoLoop() Dim MyCell As Variant, Rng As Range Dim myFile As String, myType As String Set Rng = Sheets("Sheet1").Range("A2:A4") For Each MyCell In Rng If MyCell <> "" Then myFile = Left(MyCell, InStr(MyCell, "\") - 1) myType = Mid(MyCell, InStr(MyCell, "\") + 1) MyCell.Offset(0, 1) = GetFileProperty(myFile, myType) End If Next End Sub
|c++ reading data from file into two dimensional array||3||31|
|Excel VBA - need a reliable method for SendKeys Number lock||4||33|
|In Excel 2007, how do I need to correct this ampersand formula so it works?||2||14|
|remove data validation/drop downs when moving row to another sheet||8||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!