Automating the downloading of web page and sending it via email

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I have my PC switched on 24/7.

Is it possible to somehow instruct my pc to copy a webpage
into excel at a certain time of the day and send the
resulting spreadheet as the attachment of an email to a
pre-defined email address ?

Thanks
 
Sean,

As long as Excel is running, you can use the OnTime method to
schedule a macro to be executed at a specific time. See
www.cpearson.com/excel/ontime.htm for more details on scheduling
procedures with OnTime.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

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

Auto download of Excel files in emails 4
Sending each spreadsheet via email to a different person 2
Send a single worksheet via Outlook 3
Automating producing PDF of my Excel reports 1
Using SendMail through Access - Excel Automation 2
Email worksheets via name on worksheet 4
Huge spam operator accidentally leaks database of 1.37 billion email addresses 4
Automation, send email or red flag if cell value exceeded 6

Back
Top