I use this code extract to delete all .xlsx in a folder but when there are no xlsx files the
code stops running.
What do I need to do to keep the code running if there are no .xlsx files
Dim ThisWorkbook As String
ThisWorkbook = ActiveWorkbook.Path
Kill ThisWorkbook & "\SCENARIOS PRICE FILES\*.XLSX"
Dim xrow As Long
xrow = 6
'create variables for the creation of the scenario worksheet and scenario workbook
Dim numbersheets As Integer