Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query
Hello,
Does any one knows why the following macro not running; sub test() Dim a a = Selection ' The is the selection in sheet ' where web address is given Sheets("Sheet2").Select Range("A1").Select ActiveCell.FormulaR1C1 = a With Selection.QueryTable.add(Connection:=a) WebSelectionType = xlAllTables WebFormatting = xlWebFormattingNone WebPreFormattedTextToColumns = True WebConsecutiveDelimitersAsOne = True WebSingleBlockTextImport = False WebDisableDateRecognition = False Refresh BackgroundQuery:=False End sub regardsImran |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |