Hello

I am new to VBA and was hopeing i could get some help. I am trying to pull data from a webpage that requires a login when you go to it. I try logging in on internet explorer and then run the recorded macro of pulling data from the web but excel does not recognize that I have logged in. Is there a way to input the login information in excel or if not is there a way to have excel use the internet explorer browser to pull the data instead. Below Is what i have tried but i get a sub/end with error. I have removed the website address below on purpose for security purposes.

After the data queries can i have it paste in a specific sheet every time where it clears the old data and adds the new one...i seems to fail at clearing the sheet when i try this.

Thanks

Sub Data()

Set App = CreateObject("InternetExplorer.Application")
With App
ActiveWorkbook.Worksheets.Add
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://employee_performance.aspx" _
, Destination:=Range("$A$1"))
.Name = "employee_performance"
.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
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub