Xld

yes vbaweeknum is a function in project

for some reason VBA is putting that space in


what i am asking if the weeknumber is in a diffrent place to
Workbooks("KPI 0044 internal Shortageswk" & CStr(VBAWeekNum(Now(), 1)) & ".xls")
maybe like

below
"KPI 0044 wk** internal Shortages"

how would i code this

Thanks

Merc