Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
With Application.FileSearch .NewSearch .LookIn = "L:\TEMP" RptName = Range("B6").Value 'VARIABLE PER DAY!!!! ComName = RptName & ".TXT" .Filename = ComName If .Execute > 0 Then 'Workbook exists do some stuff Else 'There is Not a File available do some stuff End If End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.