Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eggohead
  • Content: Threads
  • Order by date
  1. eggohead

    .lnk extension blocked by IE8

    Hello, IE8 blocks all isntances of this- I hear the bleep and the window dissappears. Ive tried everything I can think of to get to work. The only thing that works is If I hold down the Cntrl button I can then open this link - very cumbersome. Is there a setting or registry entry that I can...
  2. eggohead

    Excel line graph over two years

    Hello, trying to create a line graph that illustrates daily freqency from Nov 2009 to Jan 25 2010. The graph partitions the Jan month before Nov and does not follow logica date progression. How can I fix this?
  3. eggohead

    Outlook 2007 - Open Exchange Mailbox

    Hello, Looking for a way to open an exchange mailbox via command line or script(permissions already granted) in outlook 2007. Can this be accomplished? I basically want to open Outlook and automatically add the box and open it. - thanks for your help.
  4. eggohead

    Excel - Compare two columns choose numeric value

    Hello, I have two columns with similar data. In a third column I need to extract the numeric value of the two - whichever column has it. The problem is both columns will have text data in them and are not consistent. Need to check both columns ignoring any text in both and output the...
  5. eggohead

    Rank Data on Occurrence

    Hello, I have a huge spreadhseet of data that details sites and work orders. I need to list the top 5 worst sites (sites with the mmost work orders). Whats the best way to attack this and what formulas should I use? I thought using countif to count the occurence of each site number...but...
  6. eggohead

    Compile average based on date range

    Hello, Many Kudos to the folks helping in this forum. I have one more issue revolving around dates. I need to get the average of a column based on a date range. I used the followiong formula to retrieve a row count of dates that meet date criteria in B2 and B3...
  7. eggohead

    Count Dates that meet date range

    Hello, Im trying to count a column of dates in one sheet that meet the critera between two date values referenced in cells. In this case count rows that fall between Nov1st 2008 till the end of the month which whould return 3 in the sample of 10 rows below. Column: =Dates!L:L 3/4/09...
  8. eggohead

    Quick way to convert exported text to dates

    Hello, I have a huge list of data that was exported into a spreadsheet. The dates appear to be in text in the following format: 12/11/08 06:37 12/11/08 16:33 12/12/08 09:35 12/12/08 11:45 How can I quickly covert all of these values to dates? If I enter the cell and click enter it gets...
  9. eggohead

    Performance Alert ?

    Hello, I need to crate a performance alert in Windows (XP) that logs an application event for %Process Time over 80% that is sustained for 1 minute or more. How can set a parameter of 1 minute or more? - Thanks
  10. eggohead

    Microsoft Access Hyperlink Field

    Hello, Not sure if I set this up right. I have a table of document paths (just an index field and path Field)which contains the UNC links to documents I have i.e. \\mydoc.doc. I formated the path field as a hyperlink field. I want to be able to click on it and open the document from the...
  11. eggohead

    Execute program from cell reference

    Hello. I am trying to run a program with parameters referenced from a list in excel: row a contains a list of variable parameters row b contains a static reference to an executable c:\myapp.exe row c combines the executable and varaiable into a complete command line using &: For example...
  12. eggohead

    Excel Rank, Frequency or Count?

    I have a list of numbers all in the same column and need to rank the top 5 occurences of the list. How do I do this and what function(s) do I use?.... Rank, Frequency or Count or a combination? Heres what I am looking for - Thanks for your time rank number occurrence 1 22...
  13. eggohead

    Dual NIC's - routing web pages through one

    Hello, I have have an XP pro machine running 2 NICS. The first is connected to a corporate lan and is used for email, file sharing, etc. The second NIC is a wireless adpater connected to a seperate ISP. I want to route web traffic (all web pages I view in IE) through the second NIC and away...
  14. eggohead

    Using AT command with %systemroot% variable

    Hello, I am having some touble using %systemroot% or %windir% in an AT command to schedule a remote software installation. It works fine if use a static maping such as the c:\winnt\sytem32 or d:\winnt\sytem32. I would like to use these variables as some machines have different windows...
  15. eggohead

    Disable Statefull Firewall Cisco VPN 4.xx

    Hello, Is there any way to restrict or grey out the statefull firewall option in the vpn? I have tried modifying the vpnclient.ini file with no luck. Cisco documents how to modify the ini files but there is no metion on how to disable or remove this feature so a user does not have access to...
  16. eggohead

    Remotely Add Printer

    Hello, I am using the follwing (from Microsoft KB 189105)to add a printer to a remote machine. This works fine however it takes quite a long time to copy of the driver files to the remtote machine which is on a different subnet. How can I modify the script to use the driver files on the...
  17. eggohead

    Cisco 2980g Config

    Hello, Our adjacent tenant moved out and left us a Cisco 2980g switch (we are currently using on old Bay networks unmanaged 24 port switch). I have wiped the config on it and set it up to our gateway and it is working good on the status quo. I plan to remove our old Bay network switch and use...
  18. eggohead

    UNION STATEMENT MULTIPLE COLUMNS

    Hello, I have the following view for the 3rd quarter I need to add all 4 quarters in this view each in their respecitive columns. The only thing that will change is the qtr name (ie qt1, qtr2 etc) the sums and the date ranges, the % of target achieved will need to be at the end and calcuate all...

Part and Inventory Search

Back
Top