Web Query

[klatlap]

Hi,

I am using excel 2010 web query to import pages so i can extract data.

I am having an issue where i can't get a particular bit of data to stay in the same format as it is displayed on the web.

Here is the page http://formguide.cyberhorse.com.au/...tml?formdate=2011-07-19&track=GeeSyn&raceno=3

If you look at the page it is horse race form, now what i need is for the "Distance" , "Tack", "Slow" and "heavy" to stay in the same format, sometimes it does but other times it converts it to a date and time, any help on this would be great thanks.

here is the current import macro i have

Sub test()
Sheets("Sheet1").Select
    Sheets("Sheet1").Range("A1:I1000").Select
    Selection.ClearContents
    With Sheets("Sheet1").QueryTables.Add(Connection:= _
        "URL;" & Sheets("Data").Range("A1"), Destination:=Sheets("Sheet1").Range("$A$1"))
        .Name = False
        .FieldNames = False
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = False
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlOverwriteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .Refresh BackgroundQuery:=False
    End With
    End Sub

 

[jkoudsi]

before you run the web query format all the cells as text

then in your with statement include the following line at the bottom:

.WebDisableDateRecognition = True

Joe

 

[klatlap]

thanks

 

[klatlap]

I tried the above but it did not solve the problem.

 

[klatlap]

seams to be working now.

 

[klatlap]

I am still having the same issues, does any one have a solution.