Search results for query: *

This is a problem that appeared this morning on my work log workbook. On one but not both of my laptops. Sub InsertNewWeeklyStatTab_Click() ResetControls InsertWeeklyTab End Sub The macro is on the same 'Menu' sheet as the control button. There are six other control buttons on the...

The following code 'was' working on XP and stopped when upgraded to Win7. Suspect new Win7 security policy problem but then??? Win 7 Office 2007 SP3 Excel macro I found examples to do this some time ago but can not locate the document or website anylonger. The first...

Attempting to use your suggestion of not selecting things. Can get most to work except restoring the original activecell position on target workbook. Attempting to keep screen flashing between workbook and worksheets to a minimum. Below is a demo macro to illustrate my dilemma. I have two...

Attempting to download a S & P stock market graph. This snippet works under Excel 2007 but fails under 2003. I have tried many variations from this web site and others with no closer solution. oXML.Send line fails with status code of 2029 Sub dbins() Dim cText As String Dim...

Attempting to download a S & P stock market graph. This snipped works under Excel 2007 but fails under 2003. I have tried many variations from this web site and others with no closer solution. Sub dbins() Dim cText As String Dim oXML As Object Dim oResp Dim vLocalFile...

Attempting to write a function or cell formula that will update a target cell, B132, if the current cell, B133, is larger. Cell B133 contains #Value! after function reaches the .Value = nNew assignment. If B132 is greater than MAX(B6:B130) then all is well and B133 displays the value for...

Have a JAVA based web page we are attempting to click a button on. There is no source presented under IE View/Source. How do we identify the getelementsTabName("???") string? We have no access to the web page source. Is there a way to walk the object in Excel object browser to locate all...

When local Win2K server has static IP assignment responst time to opening folders and documents is very slow, 30-90 seconds. If Win2k server obtains its IP address via DHCP from the PIX box responses are under 5 seconds. Setup local PC as temp server and worked 5x5 (PC had dhcp...

Have several interfaces, pau0/slot:1/mod:1, with an 'admin status' of DOWN. ras1500> list interface INTERFACES Interface Oper Admin Name Status Status brd Down Up rm0/eth:1 Up Up rm0/wan:1 Up Up fwire...