Close a window properly vba

[3thr3e]

Hi,

I am currently writing a macro which calls on a few other macros (within the file). The file names is:

"999 Report WE 170911.xls"

However, each week I copy the file and rename it to the appropriate week ending and update the weeks data.

At the moment I have this line in my code:

Application.Run "'999 Report WE 170911.xls'!DelD"

(So it's just running a macro from within my file)

Obviously that file name is not the file name every week as the dates change.

eg. for the week after, I would need it to read...

Application.Run "'999 Report WE 240911.xls'!DelD"

and so on..

Is there anyway I can set it to do this eithout manually editing the macro each week?

Hope the above makes sense!

Thanks

 

[Jon von der Heyden]

Since the macro is in the same file that you run it from you could just use:

Call DelD

or

Application.Run "DelD"

No need to qualify the file name.

 

[3thr3e]

Since the macro is in the same file that you run it from you could just use:

Call DelD

or

Application.Run "DelD"

No need to qualify the file name.

Thank you