|
-
May 10th, 2001, 10:07 AM
#1
code help
The following code all gets me to the same point...Which would be the best way to go from a macro in excel so I can then save the opened web page as a text file ? How would the code look if it were to use the IE menu option "File, Save as, Text file. ? Tkx 
****************************************
'#1
Set IE = New SHDocVw.InternetExplorer
IE.Visible = True
IE.navigate "http://www.barchart.com"
'#2
Set IE = CreateObject("InternetExplorer.application")
IE.Visible = True
IE.navigate "http://www.barchart.com"
'#3
ActiveWorkbook.FollowHyperlink Address:="http://www.barchart.com/", _
NewWindow:=False, AddHistory:=False
****************************************
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|