Copy all Files From K:\ drive to a folder

I have a macro that works but I'm trying to schedule it with Windows Scheduler to run at a certain time in the "Run whether user is logged on or not" mode. I have multiple macro's that I'm doing the same thing and have no problems with them. This macro is set up as WorkBook_Open and runs great when I double click on it and also in the "Run only when user is logged on" mode. I am at a loss. I have looked at everything on this site about copying along with all over the internet and i've tried every code I could find. Some worked some did not, but none worked in the "Run whether user is logged on or not" mode. Any help would be appreciated.
The files are all .txt files.
I'm on a work computer and have Admin Rights
Windows 7 Enterprise
Microsoft Office Professional Plus 2007

Private Sub WorkBook_Open()
'CopyAllFiles

Dim oFso As Object
Set oFso = CreateObject("Scripting.FileSystemObject")
oFso.CopyFile "K:\*.*", "\\RETUS211-NT0001.ikea.com\Common\Logistics\Chris\K_Drive\2013\today"


'ThisWorkbook.Saved = True
'Application.Quit

ActiveWorkbook.Save
ActiveWorkbook.Close

End Sub