Results 1 to 2 of 2

Automatic macro update

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    Zagreb
    Posts
    9

    Automatic macro update

    This is my web query which I update every day by changinig date on web site.
    I recorded a macro and only thing that changes every day is date

    Now, my question is can I automaticly change the date by importing it from the specific cells, concrete, in the user interface in first workbook I have 3 cells in which user can choose day month and year
    Please help!

    Sub zagreb()
    '
    ' zagreb Macro
    ' Macro recorded 4.12.2008 by Marin Cerjan
    '
    
    '
        Sheets("Sheet2").Select
        Cells.Select
        With Selection.QueryTable
            .Connection = _
            "URL;[url]http://croatian.wunderground.com/history/airport/LDZA/2008/12/2/DailyHistory.html?req_city=NA&req_state=NA&req_statename=NA"
            .WebSelectionType = xlSpecifiedTables
            .WebFormatting = xlWebFormattingNone
            .WebTables = "14,23"
            .WebPreFormattedTextToColumns = True
            .WebConsecutiveDelimitersAsOne = True
            .WebSingleBlockTextImport = False
            .WebDisableDateRecognition = False
            .WebDisableRedirections = False
            .Refresh BackgroundQuery:=False
        End With
    End Sub
    Last edited by Homeboy_8; 12-08-2008 at 12:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1