Posts by Johnnyv015

    I figured it out!!!



    I was looking to use this formula to figure actual averages across TONS of 0's/ blanks in the data set.



    I was able to use a SUMIFS formula with this formula to divide the sum of the date range by days worked.




    I was able to use the following to achieve this:


    :oops:

    Quote

    =NETWORKDAYS(AD2,AE2,Holidays)

    :oops:


    this generates my count of working days for the month, "holidays" references a list I created of Holidays scheduled closed in the office.


    Once I generated a count of days in each month I was able to vlookup this for my number to divide by.


    Full formula below:


    Quote

    =SUMIFS('Sheet1'!$H:$H,'Sheet1'!$C:$C,Sheet2!$A2,'Sheet1'!$U:$U,Sheet2!$J$1)/VLOOKUP($V$1,$AF:$AG,2,FALSE)



    Vlookup references the results from the first formula.



    Can't believe this took me the time it did... :thanx:

    Hello, looking for a formula that will generate a count of the workdays (Monday - Friday) without holidays for any given month of any year.



    Anyone have any suggestion on a simple way of achieving this task?



    I would also like to run this out for future months/years so flexibility would be nice.



    Thanks!

    Hello,


    Thanks for the response!


    I have been validating the save information for the file path using a msgbox. I can confirm that it is using the correct naming convention.




    However I am still seeing the same problem.





    My company has recently converted to "One Drive" linked drives for all systems, could this be the cause for the errors I am seeing?





    If so does anyone have experience with these and have a workaround for saving files to a sharepoint linked drive?





    John

    Howdy all,



    I have put a code together I am trying to use that Updates a spreadsheet then saves as a Tab Delimited Text file with a filename based off a cell refrence as well as the date updated.





    Code is as follows:



    I am able to run through the entire code without issues until I hit the save. This flags with a 1004 error every run.




    Thanks for the help! You guys are the REAL MVPs!!!!!
    :cheers:

    Hello, I have an excel file I am using to update a pdf everytime the excel file is closed. However I am running in to the issue where other users may be accessing this pdf across the shared network giving me an error on attempting to save the updates. Is there any way to force close the pdf prior to saving? Or maybe set a time limit for viewing the pdf?


    Not sure how to approach this issue. Any help is greatly appreciated.



    Thanks!

    Hello,


    I have been working on a project for a few days and have come to a road block. I am trying to pull data from a table in IE into my workbook using VBA.


    The code I have currently logs into our system, navigates through a few links and drop downs. enters a date range and gets the report. Now I am just having problems pulling the data from this report into excel.


    Here is the HTML code for the table I am working with.


    Code
    1. <body class=" x-body x-ie x-ie7p x-ie7 x-ie7m x-ie8m x-ie9m x-ie78 x-nbr x-nlg" id="ext-gen1018"><table><tbody><tr><td><img src="/images/mc.gif"></td><td valign="bottom">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="/images/adhoc.gif"></td><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td><table cellspacing="2" cellpadding="2"><tbody><tr><td align="left">Favorites:</td></tr><tr><td id="tdFav" valign="bottom"><table class="x-field x-table-plain x-form-item x-form-type-text x-field-default" id="cmbFav" style="width: 200px; table-layout: fixed;" cellpadding="0"><tbody><tr class="x-form-item-input-row" id="cmbFav-inputRow" role="presentation"><td width="105" class="x-field-label-cell" id="cmbFav-labelCell" role="presentation" valign="top" style="display: none;" halign="left"><label class="x-form-item-label x-unselectable x-form-item-label-left" id="cmbFav-labelEl" style="width: 100px; margin-right: 5px;" for="cmbFav-inputEl" unselectable="on"></label></td><td class="x-form-item-body " id="cmbFav-bodyEl" role="presentation" style="width: 100%;" colspan="3"><table class="x-form-trigger-wrap" id="cmbFav-triggerWrap" style="width: 100%; table-layout: fixed;" cellspacing="0" cellpadding="0"><tbody><tr><td class="x-form-trigger-input-cell" id="cmbFav-inputCell" style="width: 100%; padding-right: 8px;"><div class="x-hide-display x-form-data-hidden" id="ext-gen1049" role="presentation"></div><input name="cmbFav-inputEl" class="x-form-field x-form-text " id="cmbFav-inputEl" aria-invalid="false" style="width: 100%;" data-errorqtip="" autocomplete="off"></td><td class=" x-trigger-cell x-unselectable" id="ext-gen1048" valign="top" style="width: 17px;"><div class="x-trigger-index-0 x-form-trigger x-form-arrow-trigger x-form-trigger-first" id="ext-gen1047" role="button"></div></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table><div id="divMenu"><div class="x-toolbar x-toolbar-default x-box-layout-ct" id="toolbar-1009"><div class="x-box-inner " id="toolbar-1009-innerCt" role="presentation" style="width: 1255px; height: 22px;"><div class="x-box-target" id="toolbar-1009-targetEl" style="width: 1255px;"><a tabindex="0" class="x-btn x-unselectable x-btn-toolbar x-box-item x-toolbar-item x-btn-default-toolbar-small x-noicon x-btn-noicon x-btn-default-toolbar-small-noicon" id="button-1010" role="button" style="margin: 0px; left: 0px; top: 0px; right: auto;" hidefocus="" unselectable="on"><table class="x-table-plain" cellpadding="0"><tbody><tr><td class="x-frame-tl x-btn-tl x-btn-default-toolbar-small-tl x-btn-default-toolbar-small-noicon-tl" id="button-1010-frame1TL" role="presentation"></td><td class="x-frame-tc x-btn-tc x-btn-default-toolbar-small-tc x-btn-default-toolbar-small-noicon-tc" id="button-1010-frame1TC" role="presentation"></td><td class="x-frame-tr x-btn-tr x-btn-default-toolbar-small-tr x-btn-default-toolbar-small-noicon-tr" id="button-1010-frame1TR" role="presentation"></td></tr><tr><td class="x-frame-ml x-btn-ml x-btn-default-toolbar-small-ml x-btn-default-toolbar-small-noicon-ml" id="button-1010-frame1ML" role="presentation"></td><td class="x-frame-mc x-btn-mc x-btn-default-toolbar-small-mc x-btn-default-toolbar-small-noicon-mc" id="button-1010-frame1MC" role="presentation"><span class="x-btn-wrap" id="button-1010-btnWrap" unselectable="on"><span class="x-btn-button" id="button-1010-btnEl"><span class="x-btn-inner x-btn-inner-center" id="button-1010-btnInnerEl" unselectable="on">Logout</span><span class="x-btn-icon-el " id="button-1010-btnIconEl" role="img" unselectable="on"></span></span></span></td><td class="x-frame-mr x-btn-mr x-btn-default-toolbar-small-mr x-btn-default-toolbar-small-noicon-mr" id="button-1010-frame1MR" role="presentation"></td></tr><tr><td class="x-frame-bl x-btn-bl x-btn-default-toolbar-small-bl x-btn-default-toolbar-small-noicon-bl" id="button-1010-frame1BL" role="presentation"></td><td class="x-frame-bc x-btn-bc x-btn-default-toolbar-small-bc x-btn-default-toolbar-small-noicon-bc" id="button-1010-frame1BC" role="presentation"></td><td class="x-frame-br x-btn-br x-btn-default-toolbar-small-br x-btn-default-toolbar-small-noicon-br" id="button-1010-frame1BR" role="presentation"></td></tr></tbody></table></a><a tabindex="0" class="x-btn x-unselectable x-btn-toolbar x-box-item x-toolbar-item x-btn-default-toolbar-small x-noicon x-btn-noicon x-btn-default-toolbar-small-noicon" id="button-1011" role="button" style="margin: 0px; left: 49px; top: 0px; right: auto;" hidefocus="" unselectable="on"><table class="x-table-plain" cellpadding="0"><tbody><tr><td class="x-frame-tl x-btn-tl x-btn-default-toolbar-small-tl x-btn-default-toolbar-small-noicon-tl" id="button-1011-frame1TL" role="presentation"></td><td class="x-frame-tc x-btn-tc x-btn-default-toolbar-small-tc x-btn-default-toolbar-small-noicon-tc" id="button-1011-frame1TC" role="presentation"></td><td class="x-frame-tr x-btn-tr x-btn-default-toolbar-small-tr x-btn-default-toolbar-small-noicon-tr" id="button-1011-frame1TR" role="presentation"></td></tr><tr><td class="x-frame-ml x-btn-ml x-btn-default-toolbar-small-ml x-btn-default-toolbar-small-noicon-ml" id="button-1011-frame1ML" role="presentation"></td><td class="x-frame-mc x-btn-mc x-btn-default-toolbar-small-mc x-btn-default-toolbar-small-noicon-mc" id="button-1011-frame1MC" role="presentation"><span class="x-btn-wrap" id="button-1011-btnWrap" unselectable="on"><span class="x-btn-button" id="button-1011-btnEl"><span class="x-btn-inner x-btn-inner-center" id="button-1011-btnInnerEl" unselectable="on">Query</span><span class="x-btn-icon-el " id="button-1011-btnIconEl" role="img" unselectable="on"></span></span></span></td><td class="x-frame-mr x-btn-mr x-btn-default-toolbar-small-mr x-btn-default-toolbar-small-noicon-mr" id="button-1011-frame1MR" role="presentation"></td></tr><tr><td class="x-frame-bl x-btn-bl x-btn-default-toolbar-small-bl x-btn-default-toolbar-small-noicon-bl" id="button-1011-frame1BL" role="presentation"></td><td class="x-frame-bc x-btn-bc x-btn-default-toolbar-small-bc x-btn-default-toolbar-small-noicon-bc" id="button-1011-frame1BC" role="presentation"></td><td class="x-frame-br x-btn-br x-btn-default-toolbar-small-br x-btn-default-toolbar-small-noicon-br" id="button-1011-frame1BR" role="presentation"></td></tr></tbody></table></a><a tabindex="0" class="x-btn x-unselectable x-btn-toolbar x-box-item x-toolbar-item x-btn-default-toolbar-small x-noicon x-btn-noicon x-btn-default-toolbar-small-noicon" id="button-1012" role="button" style="margin: 0px; left: 94px; top: 0px; right: auto;" hidefocus="" unselectable="on"><table class="x-table-plain" cellpadding="0"><tbody><tr><td class="x-frame-tl x-btn-tl x-btn-default-toolbar-small-tl x-btn-default-toolbar-small-noicon-tl" id="button-1012-frame1TL" role="presentation"></td><td class="x-frame-tc x-btn-tc x-btn-default-toolbar-small-tc x-btn-default-toolbar-small-noicon-tc" id="button-1012-frame1TC" role="presentation"></td><td class="x-frame-tr x-btn-tr x-btn-default-toolbar-small-tr x-btn-default-toolbar-small-noicon-tr" id="button-1012-frame1TR" role="presentation"></td></tr><tr><td class="x-frame-ml x-btn-ml x-btn-default-toolbar-small-ml x-btn-default-toolbar-small-noicon-ml" id="button-1012-frame1ML" role="presentation"></td><td class="x-frame-mc x-btn-mc x-btn-default-toolbar-small-mc x-btn-default-toolbar-small-noicon-mc" id="button-1012-frame1MC" role="presentation"><span class="x-btn-wrap" id="button-1012-btnWrap" unselectable="on"><span class="x-btn-button" id="button-1012-btnEl"><span class="x-btn-inner x-btn-inner-center" id="button-1012-btnInnerEl" unselectable="on">Group</span><span class="x-btn-icon-el " id="button-1012-btnIconEl" role="img" unselectable="on"></span></span></span></td><td class="x-frame-mr x-btn-mr x-btn-default-toolbar-small-mr x-btn-default-toolbar-small-noicon-mr" id="button-1012-frame1MR" role="presentation"></td></tr><tr><td class="x-frame-bl x-btn-bl x-btn-default-toolbar-small-bl x-btn-default-toolbar-small-noicon-bl" id="button-1012-frame1BL" role="presentation"></td><td class="x-frame-bc x-btn-bc x-btn-default-toolbar-small-bc x-btn-default-toolbar-small-noicon-bc" id="button-1012-frame1BC" role="presentation"></td><td class="x-frame-br x-btn-br x-btn-default-toolbar-small-br x-btn-default-toolbar-small-noicon-br" id="button-1012-frame1BR" role="presentation"></td></tr></tbody></table></a><div class="x-component x-box-item x-toolbar-item x-component-default" id="tbfill-1013" style="margin: 0px; left: 139px; top: 11px; width: 818px; height: 0px; right: auto;"></div><table class="x-field x-table-plain x-form-item x-form-type-text x-field-toolbar x-box-item x-toolbar-item x-field-default-toolbar x-hbox-form-item" id="cmbSearchBy" style="margin: 0px; left: 959px; top: 1px; width: 100px; right: auto; table-layout: fixed;" cellpadding="0"><tbody><tr class="x-form-item-input-row" id="cmbSearchBy-inputRow" role="presentation"><td width="105" class="x-field-label-cell" id="cmbSearchBy-labelCell" role="presentation" valign="top" style="display: none;" halign="left"><label class="x-form-item-label x-unselectable x-form-item-label-left" id="cmbSearchBy-labelEl" style="width: 100px; margin-right: 5px;" for="cmbSearchBy-inputEl" unselectable="on"></label></td><td class="x-form-item-body " id="cmbSearchBy-bodyEl" role="presentation" style="width: 100%;" colspan="3"><table class="x-form-trigger-wrap" id="cmbSearchBy-triggerWrap" style="width: 100%; table-layout: fixed;" cellspacing="0" cellpadding="0"><tbody><tr><td class="x-form-trigger-input-cell" id="cmbSearchBy-inputCell" style="width: 100%; padding-right: 8px;"><div class="x-hide-display x-form-data-hidden" id="ext-gen1042" role="presentation"></div><input name="cmbSearchBy-inputEl" class="x-form-field x-form-text " id="cmbSearchBy-inputEl" aria-invalid="false" style="width: 100%;" value="Query Name" data-errorqtip="" autocomplete="off"></td><td class=" x-trigger-cell x-unselectable" id="ext-gen1041" valign="top" style="width: 17px;"><div class="x-trigger-index-0 x-form-trigger x-form-arrow-trigger x-form-trigger-first" id="ext-gen1040" role="button"></div></td></tr></tbody></table></td></tr></tbody></table><div class="x-toolbar-spacer x-box-item x-toolbar-item x-toolbar-spacer-default" id="tbspacer-1014" style="margin: 0px; left: 1061px; top: 5px; right: auto;"></div><table class="x-field x-table-plain x-form-item x-form-type-text x-field-toolbar x-box-item x-toolbar-item x-field-default-toolbar x-hbox-form-item" id="searchVal" style="margin: 0px; left: 1065px; top: 1px; width: 100px; right: auto; table-layout: fixed;" cellpadding="0"><tbody><tr class="x-form-item-input-row" id="searchVal-inputRow" role="presentation"><td width="105" class="x-field-label-cell" id="searchVal-labelCell" role="presentation" valign="top" style="display: none;" halign="left"><label class="x-form-item-label x-unselectable x-form-item-label-left" id="searchVal-labelEl" style="width: 100px; margin-right: 5px;" for="searchVal-inputEl" unselectable="on"></label></td><td class="x-form-item-body " id="searchVal-bodyEl" role="presentation" style="width: 100%; padding-right: 8px;" colspan="3"><input name="searchVal-inputEl" class="x-form-field x-form-text " id="searchVal-inputEl" aria-invalid="false" style="width: 100%;" size="1" data-errorqtip="" autocomplete="off"></td></tr></tbody></table><a tabindex="0" class="x-btn x-unselectable x-btn-toolbar x-box-item x-toolbar-item x-btn-default-toolbar-small x-icon x-btn-icon x-btn-default-toolbar-small-icon" id="btnSearch" role="button" style="margin: 0px; left: 1167px; top: 0px; right: auto;" hidefocus="" unselectable="on"><table class="x-table-plain" cellpadding="0"><tbody><tr><td class="x-frame-tl x-btn-tl x-btn-default-toolbar-small-tl x-btn-default-toolbar-small-icon-tl" id="btnSearch-frame1TL" role="presentation"></td><td class="x-frame-tc x-btn-tc x-btn-default-toolbar-small-tc x-btn-default-toolbar-small-icon-tc" id="btnSearch-frame1TC" role="presentation"></td><td class="x-frame-tr x-btn-tr x-btn-default-toolbar-small-tr x-btn-default-toolbar-small-icon-tr" id="btnSearch-frame1TR" role="presentation"></td></tr><tr><td class="x-frame-ml x-btn-ml x-btn-default-toolbar-small-ml x-btn-default-toolbar-small-icon-ml" id="btnSearch-frame1ML" role="presentation"></td><td class="x-frame-mc x-btn-mc x-btn-default-toolbar-small-mc x-btn-default-toolbar-small-icon-mc" id="btnSearch-frame1MC" role="presentation"><span class="x-btn-wrap" id="btnSearch-btnWrap" unselectable="on"><span class="x-btn-button" id="btnSearch-btnEl"><span class="x-btn-inner x-btn-inner-center" id="btnSearch-btnInnerEl" unselectable="on">&nbsp;</span><span class="x-btn-icon-el " id="btnSearch-btnIconEl" role="img" style='background-image: url("/images/search.ICO");' unselectable="on">&nbsp;</span></span></span></td><td class="x-frame-mr x-btn-mr x-btn-default-toolbar-small-mr x-btn-default-toolbar-small-icon-mr" id="btnSearch-frame1MR" role="presentation"></td></tr><tr><td class="x-frame-bl x-btn-bl x-btn-default-toolbar-small-bl x-btn-default-toolbar-small-icon-bl" id="btnSearch-frame1BL" role="presentation"></td><td class="x-frame-bc x-btn-bc x-btn-default-toolbar-small-bc x-btn-default-toolbar-small-icon-bc" id="btnSearch-frame1BC" role="presentation"></td><td class="x-frame-br x-btn-br x-btn-default-toolbar-small-br x-btn-default-toolbar-small-icon-br" id="btnSearch-frame1BR" role="presentation"></td></tr></tbody></table></a><div class="x-toolbar-separator x-toolbar-separator-horizontal x-box-item x-toolbar-item" id="tbseparator-1015" style="margin: 0px; left: 1191px; top: 4px; right: auto;"></div><a tabindex="0" class="x-btn x-unselectable x-btn-toolbar x-box-item x-toolbar-item x-btn-default-toolbar-small x-noicon x-btn-noicon x-btn-default-toolbar-small-noicon" id="button-1016" role="button" style="margin: 0px; left: 1195px; top: 0px; right: auto;" hidefocus="" unselectable="on"><table class="x-table-plain" cellpadding="0"><tbody><tr><td class="x-frame-tl x-btn-tl x-btn-default-toolbar-small-tl x-btn-default-toolbar-small-noicon-tl" id="button-1016-frame1TL" role="presentation"></td><td class="x-frame-tc x-btn-tc x-btn-default-toolbar-small-tc x-btn-default-toolbar-small-noicon-tc" id="button-1016-frame1TC" role="presentation"></td><td class="x-frame-tr x-btn-tr x-btn-default-toolbar-small-tr x-btn-default-toolbar-small-noicon-tr" id="button-1016-frame1TR" role="presentation"></td></tr><tr><td class="x-frame-ml x-btn-ml x-btn-default-toolbar-small-ml x-btn-default-toolbar-small-noicon-ml" id="button-1016-frame1ML" role="presentation"></td><td class="x-frame-mc x-btn-mc x-btn-default-toolbar-small-mc x-btn-default-toolbar-small-noicon-mc" id="button-1016-frame1MC" role="presentation"><span class="x-btn-wrap" id="button-1016-btnWrap" unselectable="on"><span class="x-btn-button" id="button-1016-btnEl"><span class="x-btn-inner x-btn-inner-center" id="button-1016-btnInnerEl" unselectable="on">Favorites</span><span class="x-btn-icon-el " id="button-1016-btnIconEl" role="img" unselectable="on"></span></span></span></td><td class="x-frame-mr x-btn-mr x-btn-default-toolbar-small-mr x-btn-default-toolbar-small-noicon-mr" id="button-1016-frame1MR" role="presentation"></td></tr><tr><td class="x-frame-bl x-btn-bl x-btn-default-toolbar-small-bl x-btn-default-toolbar-small-noicon-bl" id="button-1016-frame1BL" role="presentation"></td><td class="x-frame-bc x-btn-bc x-btn-default-toolbar-small-bc x-btn-default-toolbar-small-noicon-bc" id="button-1016-frame1BC" role="presentation"></td><td class="x-frame-br x-btn-br x-btn-default-toolbar-small-br x-btn-default-toolbar-small-noicon-br" id="button-1016-frame1BR" role="presentation"></td></tr></tbody></table></a></div></div></div></div><hr>
    2. <script type="text/javascript">function ButtonHandlerOnEnterKey(button, objEvent){ if(objEvent.getKey() == 13) { button.handler.call(button.scope); }}Ext.onReady(function(){ favStore = new Ext.data.JsonStore({autoLoad:true, fields:[{name:'qID', type:'int'}, 'qName'], proxy:{type:'ajax', url:'jsonfavoritelist', reader:{root:'favoriveList', type:'json'}} }); var cmbFav = Ext.create('Ext.form.field.ComboBox', {id:'cmbFav', store:favStore, valueField:'qID', displayField:'qName', typeAhead:true, forceSelection:true, queryMode:'local', width:200, renderTo:'tdFav', listeners:{select:function(cb, rec, ind){document.location = 'queryparams?QueryID=' + cb.getValue();}} });});</script>
    3. <div align="center"><form name="Form1" method="post"><input name="Sort" type="hidden" value="1"> <input name="LastSort" type="hidden" value="1"> <input name="SortDesc" type="hidden" value="0"> <h2>Result of the New Jobs Remaining- Updated to match better 11/20/13 report</h2><table><tbody><tr><td><b>Start Date Inclusive:</b>&nbsp;10/01/14 </td><td>&nbsp;&nbsp;</td><td><b>End Date Inclusive:</b>&nbsp;10/01/14 </td><td>&nbsp;&nbsp;</td></tr></tbody></table><table width="90%" border="1" cellspacing="0" cellpadding="2"><tbody><tr><th bgcolor="#ffaa00"><a onclick="if (document.Form1.Sort.value==1) { if (document.Form1.SortDesc.value==0) document.Form1.SortDesc.value=1; else document.Form1.SortDesc.value=0; } else document.Form1.SortDesc.value=0; document.Form1.Sort.value=1;document.Form1.submit();" href="#">FLOORTYPE</a> <font face="symbol">ß</font></th><th bgcolor="#ffaa00"><a onclick="if (document.Form1.Sort.value==2) { if (document.Form1.SortDesc.value==0) document.Form1.SortDesc.value=1; else document.Form1.SortDesc.value=0; } else document.Form1.SortDesc.value=0; document.Form1.Sort.value=2;document.Form1.submit();" href="#">CLOSESTATUSDESC</a></th><th bgcolor="#ffaa00"><a onclick="if (document.Form1.Sort.value==3) { if (document.Form1.SortDesc.value==0) document.Form1.SortDesc.value=1; else document.Form1.SortDesc.value=0; } else document.Form1.SortDesc.value=0; document.Form1.Sort.value=3;document.Form1.submit();" href="#">COUNT(1)</a></th></tr><tr bgcolor="#ffffff"><td width="20%" align="center">Cpt </td><td>Built Quote </td><td>38 </td></tr><tr bgcolor="#eeeeee"><td width="20%" align="center">Cpt </td><td>Customer Issue </td><td>72 </td></tr><tr bgcolor="#ffffff"><td width="20%" align="center">Cpt </td><td>Installer Issue </td><td>5 </td></tr><tr bgcolor="#eeeeee"><td width="20%" align="center">HS </td><td>Built Quote </td><td>8 </td></tr><tr bgcolor="#ffffff"><td width="20%" align="center">HS </td><td>Customer Issue </td><td>50 </td></tr><tr bgcolor="#eeeeee"><td width="20%" align="center">HS </td><td>Installer Issue </td><td>93 </td></tr></tbody></table><input name="QueryID" id="QueryID" type="hidden" value="689"> <input name="JustReport" type="hidden" value="1"> <input name="ReportName" type="hidden" value="New Jobs Remaining- Updated to match better 11/20/13"> <input name="p1" id="p1" type="hidden" value="10/01/14"> <input name="pn1" type="hidden" value="Start" date="" inclusive=""> <input name="p2" id="p2" type="hidden" value="10/01/14"> <input name="pn2" type="hidden" value="End" date="" inclusive=""> </form></div><div class="x-btn-default-toolbar-small-frameInfo" style="top: -10000px; position: absolute;"></div><div class="x-tip x-layer x-tip-default" id="ext-quicktips-tip" style="display: none;"><div class="x-tip-header x-header x-header-horizontal x-docked x-unselectable x-tip-header-default x-horizontal x-tip-header-horizontal x-tip-header-default-horizontal x-top x-tip-header-top x-tip-header-default-top x-docked-top x-tip-header-docked-top x-tip-header-default-docked-top" id="ext-quicktips-tip_header"><div class="x-header-body x-tip-header-body x-tip-header-body-default x-tip-header-body-horizontal x-tip-header-body-default-horizontal x-tip-header-body-top x-tip-header-body-default-top x-tip-header-body-docked-top x-tip-header-body-default-docked-top x-box-layout-ct x-tip-header-body-default-horizontal x-tip-header-body-default-top x-tip-header-body-default-docked-top" id="ext-quicktips-tip_header-body"><div class="x-box-inner " id="ext-quicktips-tip_header-innerCt" role="presentation"><div class="x-box-target" id="ext-quicktips-tip_header-targetEl"><div class="x-component x-header-text-container x-tip-header-text-container x-tip-header-text-container-default x-box-item x-component-default" id="ext-quicktips-tip_header_hd" unselectable="on"><span class="x-header-text x-tip-header-text x-tip-header-text-default" id="ext-quicktips-tip_header_hd-textEl" unselectable="on">&nbsp;</span></div></div></div></div></div><table class="x-table-plain" cellpadding="0"><tbody><tr><td class="x-frame-tl x-tip-tl x-tip-default-tl" id="ext-quicktips-tip-frame1TL" role="presentation"></td><td class="x-frame-tc x-tip-tc x-tip-default-tc" id="ext-quicktips-tip-frame1TC" role="presentation"></td><td class="x-frame-tr x-tip-tr x-tip-default-tr" id="ext-quicktips-tip-frame1TR" role="presentation"></td></tr><tr><td class="x-frame-ml x-tip-ml x-tip-default-ml" id="ext-quicktips-tip-frame1ML" role="presentation"></td><td class="x-frame-mc x-tip-mc x-tip-default-mc" id="ext-quicktips-tip-frame1MC" role="presentation"><div style="position: relative;"></div><div class="x-tip-body x-tip-body-default x-tip-body-default" id="ext-quicktips-tip-body"><table class="x-table-plain" id="ext-quicktips-tip-outerCt"><tbody><tr><td id="ext-quicktips-tip-innerCt" style="padding: 0px; vertical-align: top;"><div class="x-clear" id="ext-quicktips-tip-clearEl" role="presentation"></div></td></tr></tbody></table></div></td><td class="x-frame-mr x-tip-mr x-tip-default-mr" id="ext-quicktips-tip-frame1MR" role="presentation"></td></tr><tr><td class="x-frame-bl x-tip-bl x-tip-default-bl" id="ext-quicktips-tip-frame1BL" role="presentation"></td><td class="x-frame-bc x-tip-bc x-tip-default-bc" id="ext-quicktips-tip-frame1BC" role="presentation"></td><td class="x-frame-br x-tip-br x-tip-default-br" id="ext-quicktips-tip-frame1BR" role="presentation"></td></tr></tbody></table><div class="x-tip-anchor x-tip-anchor-top" id="ext-gen1024"></div></div></body>


    You will see the data needed in the TD lines of code. All I need is the number amounts.


    Thanks,
    John

    Re: Select from a drop down menu using VBA


    Thanks for the help, But I have solved this problem. for future reference the code is listed below.


    Code
    1. Set oSelect = MyBrowser.document.getElementById("CatID")
    2. oSelect.Focus
    3. oSelect.selectedIndex = 6
    4. oSelect.FireEvent "onchange"


    this selects the 6th option from the top in this drop box.

    Hello, I am working on a VBA code that will navigate through several links then enter a date range and run a report.


    As of now I have everything working except the Sendkeys function for entering the date range.



    As you can see in the code, on the last page I am prompted with 2 calendars for selecting the dates .


    The dates selected will ALWAYS be yesterday.


    When navigating through this via mouse, you simply click the calendar and press the left arrow then enter. This will input yesterdays date.


    Now for some reason my sendkeys line is not executing in IE.


    Is there anything I should add to this as to link it to IE or the calendar?


    Any push in the right direction would be a great help.


    Also this is the HTML code for the calendar boxes on the page.




    So my problem here, is I need the SendKeys function to Act in the calendar box that pops up when "ext-gen1054" and "ext-gen1056" are selected.




    Thanks,
    John

    Hello, I am working on a VBA code that will navigate through several links then enter a date range and run a report.


    As of now I have everything working except the Sendkeys function for entering the date range.



    As you can see in the code, on the last page I am prompted with 2 calendars for selecting the dates .


    The dates selected will ALWAYS be yesterday.


    When navigating through this via mouse, you simply click the calendar and press the left arrow then enter. This will input yesterdays date.


    Now for some reason my sendkeys line is not executing in IE.


    Is there anything I should add to this as to link it to IE or the calendar?


    Any push in the right direction would be a great help.


    Also this is the HTML code for the calendar boxes on the page.




    Thanks,
    John

    Hello, I am trying to click on a specific option in a drop down on an IE page and I am having trouble with this code. As of now this is the code I have to access the page. Dim


    Now I need to click on a drop down and select an option from a list(in the same window.) Here is the HTML for the Dropdown box.



    HTML
    1. <SELECT onchange=document.frmMain.submit(); id=CatID class=Entry name=CatID> <OPTION selected value="0">-Select-</OPTION> <OPTION value="42">Business Review</OPTION> <OPTION value="29">Close Daily Dashboard</OPTION> <OPTION value="36">Close Quality Assurance</OPTION> <OPTION value="30">Close Reporting</OPTION> <OPTION value="31">Close Weekly Dashboard</OPTION> <OPTION value="18">Closing</OPTION> <OPTION value="1">Employee Lookup</OPTION> <OPTION value="5">Job Counts</OPTION> <OPTION value="44">Josh Analysis</OPTION> <OPTION value="24">Multi-Property</OPTION> <OPTION value="21">New Hire</OPTION> <OPTION value="19">Online Reservation</OPTION> <OPTION value="35">Phone</OPTION> <OPTION value="46">THD Finance</OPTION> <OPTION value="14">Tech Time Reports</OPTION></SELECT>


    Can anyone get me moving in the right direction on this project?


    Thanks! John

    Hello, I am working on a VBA code that will allow me to navigate through url links. I have as of now this


    The problem is in my "Followhyperlink" code this is running in a new window. I need this to run in the same window I logged in through previously. Any ideas on how I can approach this?