Thank you very much! Solved!! I'm ashamed but I can't solve one more problem![]()
now this is my code:
With ActiveSheet.QueryTables.Add(Connection:="URL;" & Range("N283"), Destination:=Range("$AG$1"))
.Name = "www.google.com"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
Else
End If
End Sub
I need to know what happens during the day, even when I'm not at home and my computer is off. So, how can my file run this macro at the time (shown as hh:mm) indicated in a cell (F283 in my case)? thank you so much for this and for what you've already done for me!
Bookmarks