Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA CODE TO CLOSE ACTIVE WINDOW INTERNET EXPLORE

Status
Not open for further replies.

amecari

Technical User
Mar 21, 2001
29
BR
Hi,

I`m using vba code in excel to get data from a page internet like this :

Sub Macro1()
With ActiveSheet.QueryTables.Add(Connection:="URL; _
Destination:=Range("bC7"))
.Name = "tek-tips"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With
End Sub

No problem here. My big problem is: - How I can close the internet explore active window after I finished capture data???

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top