Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
' Counts files in the directory With Application.FileSearch .LookIn = "\\xxxxx\Share\Daily\" & Range("Q3").Value .FileType = msoFileTypeExcelWorkbooks .Execute Dim found As String found = .FoundFiles.Count End With If found <> 9 Then MsgBox ("WARNING! There are only " & " " & found & " files present. You need to review prior to the rollup!") Call openDIR Else MsgBox ("There are" & " " & found & " files present. You can proceed to script rollup!") End If
|Excel VBA question, if cell is empty then replace it with specified value||8||41|
|How to create a user function to count for a particular characters in a cell||8||34|
|having troubles with an Excel Macro saving to C: on Windows 10||9||27|
|Microsoft Word Macros and VBA Scripts||3||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!