I have a **excel file that imports from weekly files**. I can **specify the number of week to import in an input box**. From this number, I construct the file path and name for that specific week and then imports it.

**In cell D1 I want to show the week that was last imported**, so if I last Imported week 12, cell D1 should show "12" and if later later I imported a file from a older week like 4, cell D1 should show "4" 

In the excel file the source files that will be imported will be trough a vba code, it don't have any type of tables in the source file, so I need to implement this in my code in order to show in the cell D1 the week that as been imported. 

I tried implementing this to my code `Range("D1").Value = WeekVal` in order to try to fill that specific cell with the number of the week that was imported.

I searched online but the ones that I saw didn't apply very well to my code. So I don't really need a date **I just need the value from the file name** that represents the week, like here : 

> 
> "Status 496 800 week -->**12**<-- 2015.xls"
> 
> 
> 

that number is what I need to show in the D1