Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you importing unicode from web
Using: Excel 2007
I want to import a table from a website using Data: From Web http://www.fallingrain.com/world/FR/a/A/b/ The table has unicode characters but when the imported finishs the characters are not correct. How do you specify the import to preserve the unicode? Macro: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www.fallingrain.com/world/FR/a/A/b", Destination:=Range("$A$1")) .Name = "Table aAb" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = "2" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create csv which contains unicode | New Users to Excel | |||
unicode | Excel Discussion (Misc queries) | |||
Importing Alan Beban's code on Arrays; Importing a module or a project | Excel Worksheet Functions | |||
Unicode | Excel Worksheet Functions | |||
Unicode Help | Excel Programming |