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!

Register Log in
  • Congratulations derfloh 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: *

  1. MJPPaba

    Excel Rules of Recalculation within "If x=y then Function A else Function B"

    anyone know? If you have a function as follows: =If(A1=B1,CountA(C1:C1000000),Sum(D1:D1000000)) when excel performs a recalc does Excel recalc both the true and the false portions of the statement or is it the same as the creating your own User Definied Function and only recalcs the True or...
  2. MJPPaba

    count top 3 text values in column

    you could use the RANK() function to establish the frequency of the values in the population.
  3. MJPPaba

    Outlook Custom Email with VB Script - need to avoid Enable/Disable Msg

    Hey, I have created an outlook custom form and distributed it to users, each time the email is opened the message box asking the user to enable/disable macros pops up. I have changed my Macro security settings from Medium to Low but this always switches back to medium as soon as i try opening...
  4. MJPPaba

    IE Button in Facebook

    Excel 2007 but can move to Access 2007 if necessary.
  5. MJPPaba

    IE Button in Facebook

    Hi All, Required: VBA to create instance of Internet Explorer (already done works) VBA to open URL, in this case Facebook users profile (ok done, works) Click like button or Add friend button in facebook? (not found solution yet) Cheers M
  6. MJPPaba

    Application.Run Problem

    ta
  7. MJPPaba

    Application.Run Problem

    Hi All, The following line doesn't seen to work Sub mdl_GetData() Application.Run ("'my workbook.xls'.'my sheet'!cmdBtn_Click") end sub Several things causing issues here: 1 there are spaces in the workbook name 2 there are spaces in the sheet name 3 the code I need to run is held within a...
  8. MJPPaba

    Excel - Conditional Format Cell based on previous cell

    if the conditional formatting needs to be copied down to a defined range you might think of using the R1C1 format of cell referencing rather than using A1, to chenge this go to Tools options and change the setting in there. For the cell to the left of the current cell this would be...
  9. MJPPaba

    Automation Excel SaveAs Error

    Please help, I am opening Excel from Access and need to resave the file with another name. Problem is not seeming to work at the moment. Please advise... Pabs Public Sub mdl_OpenSS(myDir As String, myFile As String, myProcessID As Integer) Dim myCurDir As String On Error GoTo myError...
  10. MJPPaba

    #Ref GetPivotData

    Hi Skip, We both have full access to the same network location. He has manual calc set with reclac on save switched on, if I have the same we still get the same scenario. Any other thoughts? otherwie we shall create a messy workaround? Cheers Matt
  11. MJPPaba

    #Ref GetPivotData

    hello, Getpivotdata (GPD) is causing me soem issues. On my pc GPD function is linked between two files. When close the file containing the pivot and save the file containing the GPD function the result is retained. HOWEVER! on a colleagues pc when the above is actioned to the letter, the...
  12. MJPPaba

    Macro runs as long as 60secs on Excel 2003 compared to 2002

    Has the macro got a step where a filter is applied and then the visible rows are deleted? 2003 does not work so well with this. Can you post the code? Cheese Matt
  13. MJPPaba

    VLookUp/ Index+Match to find SECOND instance

    ColA ColB ColC ColD a 1 =COUNTIF($A$2:A2,A2) =+A2&C2 b 2 =COUNTIF($A$2:A3,A3) =+A3&C3 c 3 =COUNTIF($A$2:A4,A4) =+A4&C4 d 4 =COUNTIF($A$2:A5,A5) =+A5&C5 e 5 =COUNTIF($A$2:A6,A6) =+A6&C6 f 6 =COUNTIF($A$2:A7,A7) =+A7&C7 g 7 =COUNTIF($A$2:A8,A8) =+A8&C8 h 8 =COUNTIF($A$2:A9,A9) =+A9&C9 a...
  14. MJPPaba

    DLookup a DAO Recordset

    Can anyone help me out. I currently have a query against 2 tables of data taking about 30mins to query. Not efficient I can hear you say, not able to do anything about it unfortunately. I need to extract one field from one record in a recordset of 33million records. Attempts so far include...
  15. MJPPaba

    USING MS QUERY IN EXCEL

    Hi, In principle it is quite easy, If you record a macro and go through the process of importing a sample of the data you want to a worksheet ensuring you put in a criteria you can then go into the code and amend it to allow it to become more dynamic, e.g. With...
  16. MJPPaba

    How to Write an If Statement or Vlookup Statement

    Approach from a slightly different angle... Sort the data in this order... Date Sort Descending Account Sort Ascending District Name Sort Ascending District ID Sort Ascending Area ID Sort Ascending then in cell F2 enter the following...
  17. MJPPaba

    Updating Word Macros

    best option for you save the macro and word document in a development area as a normal word document. Save the macro and word document in a suitable network location as a document template. In word go to [tools]... [templates and add-ins]...[Add]... This creates a central macro which...
  18. MJPPaba

    Excel - Autofilter problem

    no surprises there then!
  19. MJPPaba

    Excel - Autofilter problem

    could possibly be editing a cell or running a macro at the same time as trying to change the filter? Matt
  20. MJPPaba

    Calculate number of days using 360 day basis

    the dates required are in julian format, so by putting the real date into the datevalue function it is then converted into the julian date format required. Cheers Matt

Part and Inventory Search

Back
Top