Retrieving a File

[tammy zembower]

I need to set up a procedure to automatically retrieve a file(s) and send to
a printer at a specified time (6:45) everyday. I'm not that familiar with
VBA and have no idea where to start. Can anyone help me or point me in the
right direction to start this.
Thanks!
Tammy

 

[mudraker]

for starters try this

Sub PrintFile()
Workbooks.Open FileName:="C:\Temp\Test FILE.xls"

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Application.OnTime TimeValue("06:45:00"), "PrintFile",
TimeValue("06:45:10"), True

End Sub