Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
Setting in URLWebquery Table in VBA Excel 2003

Webquery table from my banking website, and it is successfully partially and some is not for the grabbing. After login bank website, there is new webpage show up to ask you input date your order request report "from" and "to" in ComboBox. Because it is used for Webquery code, so I need to put the HTMl variable name such as fromDay=28&fromMonth=06&fromYear=2010&toDay=28&toMonth=06&toYear=2010 in URL. But
it is not working for the following VBA Code for grabbing table. And then I try to navigate the
website address directly in IE, https://otherbank.com/cgi-bin/ibnkprdhk/ist/order/orderEnquiry.do?fromDay=28&fromMonth=06&fromYear=2010&toDay=28&toMonth=06&toYear=2010",
The combo box is fine and show up output with From: 28 06 2016 To:28 06 2010 in the box but I still need to click "Search" button in order to getting into the new and my target webpage of my request report so that is I know why the following Webqurey VBA code is not working because of missing such Button Search Click or hit return action I guess
I don't know how to specify the URL link with button action or hit return action. Anyone knows these
such VBA vode for hit reutrn or button click in the URL for Webquery table in VBA code. Please advise.
I try to navigate other websites in VBA such as http://finance.yahoo.com/q?s=int that will directly
and successfully go to stock ticker of Intel (INTC) webpage without any hit return or without click method specified in http link , why ?
Question-1 How to specify the Click or Hit return action or method in the URL for WbeQuery Table
in VBA Excel 2003 that is similar to specifiy HTML name variable like
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;https://otherbank.com/cgi-bin/ibnkprdhk/ist/order/orderEnquiry.do?fromDay=28&fromMonth=06&fromYear=2010&toDay=28&toMonth=06&toYear=2010",
Question-2 I try to put fromDay=28&fromMonth=06&fromYear=2010&toDay=28&toMonth=06&toYear=2010"&onlick, but
it didn't work, WHy ? Probably not...
Question-3 I Suppose it doesn't need to do anything about button click or hit return action if the
link is already specified every HTML name variable for website navigation, Anything I am missing
to do in my code, please advise
Duncan
'The orginal source code for HTML input box at such URL:/httlp. after login into bank webpage.
<input class="itemInputTwoDigit" type="text" id="fromDay" name="fromDay" maxlength="2"
value="DD" onkeyPress="clearValue(this)"/>
<input class="itemInputTwoDigit" type="text" id="fromMonth" name="fromMonth"
maxlength="2" onkeyPress="clearValue(this)"
value="MM"/>
<input class="itemInputFourDigit" type="text" id="fromYear" name="fromYear"
maxlength="4" onkeyPress="clearValue(this)"
value="YYYY"/>
<A HREF="#"
onClick="javascript:return setShowCalendar('setMultipleValues1', 'anchor10')"
name="anchor10" id="anchor10"><image src="/ist/img/cal.gif" border=0></A>
</div>
<div class="boxStyle01">
<p><label for="toDay">to :</label></p>
<input class="itemInputTwoDigit" type="text" id="toDay" name="toDay" maxlength="2"
onkeyPress="clearValue(this)" value="DD"/>
<input class="itemInputTwoDigit" type="text" id="toMonth" name="toMonth" maxlength="2"
onkeyPress="clearValue(this)" value="MM"/>
<input class="itemInputFourDigit" type="text" id="toYear" name="toYear" maxlength="4"
onkeyPress="clearValue(this)" value="YYYY"/> <A
HREF="#"
onClick="javascript:return setShowCalendar('setMultipleValues2', 'anchor11')"
name="anchor11" id="anchor11"><image src="/ist/img/cal.gif" border=0> </A>
</div>
<div class="boxStyle02">
<p><label for="selStatus">Order status:</label></p>
<select id="orderStatus" name="orderStatus">
<option value="0" selected>All</option><option value="6">Open</option><option value="8">Partially Executed</option><option value="16">Fully Executed</option><option value="64">Cancelled</option><option value="128">Expired</option><option value="33">Rejected</option>
</select>
<input type="hidden" name="searchStatus" value="searchStatus" />
<input class="itemInputButton" type="button" value='Go'
onclick="return validateOrderEnquiry()"/>
With ActiveSheet.QueryTables.Add(Connection:= _"URL;https://otherbank.com/cgi-bin/ibnkprdhk/ist/order/orderEnquiry.do?fromDay=28&fromMonth=06&fromYear=2010&toDay=28&toMonth=06&toYear=2010", _Destination:=Range("b1")) ' .Name = "Quote: " & symb .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlOverwriteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = False .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = "9" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=FalseEnd With
1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:
IT is good at least I know it has
such product in this market
Which one should buy if
I am using vista windows and IE ?
IT is good at least I know it has
such product in this market
Which one should buy if
I am using vista windows and IE ?
IT is good at least I know it has
such product in this market
Which one should buy if
I am using vista windows and IE ?
IT is good at least I know it has
such product in this market
Which one should buy if
I am using vista windows and IE ?