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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
File saved yesterday is blank today, how do I retrieve? 2
Access Making a memo in Access 0
Access #Error & Excel Pivot 0
Create Excel Lab test results 1
Retrieve data based on 3 criteria 3
Retrieve multiple dates, from a week number? 1
Essbase Retrieve 1

Back
Top