JudahRaion
New Member
- Joined
- Oct 13, 2011
- Messages
- 20
Hi guys,
I'm using a web query to take some information from a file HTML file I have, but I'm having some troubles with formating things.
In "P" column I take scientif number and Excel erase the first "00", there are any way to change this?
Here is my HTML code:
here is my web query:
Thank you a lot
I'm using a web query to take some information from a file HTML file I have, but I'm having some troubles with formating things.
In "P" column I take scientif number and Excel erase the first "00", there are any way to change this?
Here is my HTML code:
HTML:
A B C D E I O P Q R S LC 20090112 2998687 500000000 1 UPS 2 0060100000000000000000 EUR EUR 12-01-2009 7:30:54
here is my web query:
Code:
With Sheets("Trabalhar").QueryTables.Add(Connection:= _
"URL;file:" _
, Destination:=Range("$A$1"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = False
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "4"
.WebPreFormattedTextToColumns = False
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
Thank you a lot