Automating the downloading of web page and sending it via email

Sean · May 24, 2004

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

Chip Pearson · May 24, 2004

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