Help using variable in KILL command file path

[PatrickSchmidt]

Hello,
I made a macro to save a file with todays date in a folder. I'll be doing this everyday and I don't want the folder to fill with workbooks. I would like to keep yesterdays and delete the file dated the day before yesterday.
Also If anyone can give me a tip for adding in holidays to the workday function I'd really appreciate it.
Any help is greatly appreciated. Thank you!
Excel 2010
my variables and code that are not working:

Sub CleanUp()


Dim TwoDays
TwoDays = Format(WorksheetFunction.<wbr>WorkDay(Date, -2), "yyyy mm-dd")

Kill "C:\Test\ & TwoDays & TheRestOfFileName.xlsx"


End Sub

 

[VBA Geek]

you are going to need to create a list of holidays depeing on the relevant Country, excel only understands weekends, the optional argument (holidays) needs to be a list given by the user

 

[FormR]

And for the first question try:

Dim TwoDays as String

Kill "C:\Test\" & TwoDays & "TheRestOfFileName.xlsx"

 

[PatrickSchmidt]

and for the first question try:

dim twodays as string

kill "c:\test\" & twodays & "therestoffilename.xlsx"

thank you!!!!!