need to automate a sheet re-organization
On Sun, 22 Nov 2009 20:13:07 +0000, joel
wrote:
I suspect the workbook you are using that contains the macro may stil be
in 2003 format. I would create a new workbook.
No. The macro is in my personal space, not in ANY workbook.
then copy the macros
from you old workbook to the new workbook. Then retry the code.
Which verion of IE explorer are you using. The shortcuts keys wold be
part of the IE
Wrong again. The save dialogs are not part of IE, but part of the
desktop GUI. There *may* be a place where I can turn such hotkeys back
on, but they are not on by default in Windows 7 GUI dialogs.
and you may need to select in tyour IE explorer the
compatibility mode so the web browser works with older version of
webpages.
I can DL the file directly from the URL I have, and the code you
provided shows links to the page and multiple URLs. I have direct links
for the DLs. So I have no problem with my IE nor the page I am hitting.
The Sendky method I used true which is suppose to wait for the
application to process the key command before continueing.
It relies on hotkey functions which must be in place, and are not.
I only had
problems with winXP, 2003, IE version 8 with the box to close the
download box when the download was complete.
The do until isn't needed either. It is a five second DL here, and I
can allocate ten seconds for the wait, and it will already be here.
I Added a 5 second times
before sending the key.
The key sent has no function in the save dialog shown.
Meow
|