Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query output, how to format?
Hi, I have a web query which, when it places the data into the workshee insists on inserting new columns if the results of the last query hav not been deleted; With QT .Name = Cells(i, 61) .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertEntireRows .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = "27" .WebPreFormattedTextToColumns = False .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False End With QT.Refresh BackgroundQuery:=False Ideally I would like the new result set to overwrite existing dat and/or if it needs to create new cells then they should be rows, no columns. Thanks in advance for any solution -- kinmor ----------------------------------------------------------------------- kinmorr's Profile: http://www.excelforum.com/member.php...fo&userid=2417 View this thread: http://www.excelforum.com/showthread.php?threadid=37862 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Format to Text Output - A Tough One ! | New Users to Excel | |||
Format Function Output to numeric (#,###.00) | Excel Discussion (Misc queries) | |||
Combo Box - format output as time | Excel Discussion (Misc queries) | |||
User Defined Function: Format Output | Excel Programming | |||
Exporting Excel output to pdf/rtf/doc format | Excel Programming |