Recent content by IanT

  1. I

    String

    Hi I have field with data such as: YORK, @ YO17ET@ CHELMSLEY WOOD, @ B376RH@ DUDLEY, @ DY11NT@ I want to extract the data between the two @, for example: YO17ET B376RH DY11NT Can anyone help!
  2. I

    Another Indirect Issue

    Hi Brian Both formulas work great. I am using the sumproduct because I need to identify certain criteria from a data export, and the indirect allows me to identify year to date data from a previous year for comparison.
  3. I

    Another Indirect Issue

    Hi =SUMPRODUCT((A12:INDIRECT(Current!$AA$1&Current!$AA$3))) I am using the above formula to sum a range the Current ref being the end point IE A20. This works great if the A12 is the current sheet, but if I use the formula below it errors, Previous being another Sheet. Can any one help...
    • IanT
    • Thread
    • Replies: 5
    • Forum: Excel
  4. I

    Indirect formula

    Hi I am trying to get the formula below to work with out success. The M Summary is the sheet where the value is I want to bring back and the Current is where the cell reference is for example L68. Can anyone help! ='M Summary'!&INDIRECT(Current!$AG14) Thanks in advance.
    • IanT
    • Thread
    • Replies: 3
    • Forum: Excel
  5. I

    Named Range VBA

    Hi I am tryingto use the code below to update the Named Range Excel but it errors, can anyone advise why! ActiveWorkbook.Names.Add Name:="NOT", RefersToR1C1:= _ "=OFFSET(Extract!$BE$1,0,0,MATCH(" * ",Extract!$BE:BE,-1),1)"
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  6. I

    Array!

    Hi I have data in a table which I want to create a string from. There is a unique number ie SAuto. Number SAuto 03/10/00/00001 23 1323213213313 23 4165468468465 23 So I want the string to be: 03/10/00/00001 - 1323213213313 - 4165468468465 Any ideas, I think...
  7. I

    Validation Rule

    Hi The validation is on the form.
  8. I

    Validation Rule

    Hi I am trying to get a Validaytion rule to only allow three letters followed by seven numbers, for example ABC1234567 Can anyone advise as I cannot work out how to do this! Thanks in advance.
    • IanT
    • Thread
    • Replies: 2
    • Forum: Forms
  9. I

    Business Objects 5.8

    Hi Can anyone help... I want code which will open a BO document and then run code in the BO document, all this from Access... Thanks in advance.
  10. I

    Lotus Notes View

    Hi Does anyone no how to Maximize Lotus Notes with VBA when the view is Minimized.
  11. I

    VBA Import Access Data

    Hi I am using the code below to import data from access, unfortunately the code does not recognise the variable 'FindFile' in the 'ODBC;DSN=MS Access Database' section of the code, can anyone advise why!!! Sub MEU_AccessImport() Dim FindFile As String FindFile = Left(ActiveWorkbook.Path...
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  12. I

    Export Access Query Data To Excel Cell

    Is it possible to export query data in access to a specific cell in a excel workbook, tried searching not having much luck!
  13. I

    VBA Path of Current links

    Hi Does anyone have code which will identify the current path of links I have in a excel sheet!
    • IanT
    • Thread
    • Replies: 1
    • Forum: Excel
  14. I

    Number Format

    In a query I get results like: 916576.15 3230200.86 I only want to show thw values as £000s, for example: 916 3230 Can anyone advise!
  15. I

    Sub Name Variable

    Hi I am using the code below to look at a table to identify a sub name in a module that I want to run, but I get an error message saying Compile Error, expected sub. It looks like it is something to do with the sub name variable as I am using String. Can anyone help! Sub Update() Dim rNames...
See more
Top Bottom