Retrieving a File

  • Thread starter Thread starter tammy zembower
  • Start date Start date
T

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
 
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
 
Back
Top