ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automating the downloading of web page and sending it via email (https://www.excelbanter.com/excel-programming/299245-automating-downloading-web-page-sending-via-email.html)

Sean[_7_]

Automating the downloading of web page and sending it via email
 
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

Automating the downloading of web page and sending it via email
 
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



"Sean" wrote in message
...
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





All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com