LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Problems with OLECMDEXECOPT_DONTPROMPTUSER

I am trying to automatically save a list of web pages using the
following code:

Sub navigate_to_a_link_and_save_it()
Dim ie As SHDocVw.InternetExplorer
Dim ieDoc As Object
Set ie = New SHDocVw.InternetExplorer
For rw = 4 To 285
URL = ActiveSheet.Cells(rw, 1) 'a list of links, as text
ie.Visible = True
ie.Navigate URL
Do Until ie.ReadyState = READYSTATE_COMPLETE And Not ie.Busy
DoEvents
Loop
ie.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DONTPROMPTUSER
'why does this still prompt me?
Next rw
End Sub

I'm trying to get it to save the file with the default name and file
type. Is it possible to use saveas with out being prompted, and if not,
how might I automate hitting the enter button when the saveas window
pops up? And is it possible to assign a name for the file to be saved
as?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
aauugghhh...#div/o problems & various average formula problems acbel40 Excel Worksheet Functions 5 October 19th 09 05:00 PM
VBA Help Problems Kuzemdoo Dawuni Excel Programming 8 December 22nd 04 01:51 AM
Problems merging an excel file due to code or file problems? Cindy M -WordMVP- Excel Programming 0 September 14th 04 02:58 PM
Two little problems Robert Couchman[_6_] Excel Programming 2 August 12th 04 02:49 PM
can someone help me with this problems please? DEBBZ : Excel Programming 2 July 3rd 04 12:42 AM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"