Making a Macro add a date after completing action

Hey Guys

I have created a Macro that creates a new CSV from a worksheet in my workbook
What I am trying to do is make it add a the date to B5 of my sheet called gobalsettings

Each time I try I keep getting the error

Run-time error '1004'
Method 'Range' of object'_Gobal" failed

Please Login or Register  to view this content.

Thanks I tried that and got error message

Run-time error '9':
Subscript out of range

Maybe I need to switch back to the original workbook

I tried

Please Login or Register  to view this content.

But that didnt work either