We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub CheckTargetFile() Targetfile1 = "SR_" & cnty & ".txt" Dirname1 = "H:\srprod\Data Requests\" & typestudy & "Files\" & year 'To make sure that file exists With Application.FileSearch .NewSearch .LookIn = Dirname1 .Filename = Targetfile1 If .Execute() = 0 Then MsgBox "File not found. Not Created Yet", vbOKOnly Else Call Import End If End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|NEED LOOK FOR NUM||23||27|
|Excel Macro: Correct Macro that creates tabs for each "AccountSku"||4||43|
|how can i return the name of color from the cell background?||8||32|
|Custom fill series||12||35|
Join the community of 500,000 technology professionals and ask your questions.