Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save web page as desktop file from Excel/VBA
I know that I can save a web page as a file on my desktop by foing Sav
As and choosing the destination I want to be able to (in Excel/VBA) save it as a file repeatedly ove several time increments (using the OnTime method). Each time it save I want it to replace the previous version of the file. How do I d this? Thank-you -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save web page as desktop file from Excel/VBA
Hi,
If you already have the code but are intercepted with the "do you want to replace" box then use the sendkeys method to say "yes". Sendkeys initializes before the event. assuming the "Yes" button is the focus then: sendkeys ~ filesaveas filename:"xxx" if the focus is on the "No" which it usually is then you have to tab over to yes. sendkeys (TAB) sendkeys ~ filesaveas filename:"xxx" regards Mark -----Original Message----- I know that I can save a web page as a file on my desktop by foing Save As and choosing the destination I want to be able to (in Excel/VBA) save it as a file repeatedly over several time increments (using the OnTime method). Each time it saves I want it to replace the previous version of the file. How do I do this? Thank-you. --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I save an excel worksheet as my desktop image? | Excel Discussion (Misc queries) | |||
double click excel file on the desktop excel opens but not file? | Excel Discussion (Misc queries) | |||
Macro - Save file in Desktop | Excel Worksheet Functions | |||
control gif file name when I save as web page? | Excel Discussion (Misc queries) | |||
Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel |