Search results

  1. M

    Append two excel files to ms access table using VBA

    You are correct. Both sets of data should go to the Live Tracker table and the contents of that table should be deleted before I can append the data from the two tables to it. Do you have any tips on how to do this?
  2. M

    Append two excel files to ms access table using VBA

    ok I understand. I haven't added the second file yet. That is where I am stuck. At the moment the code above is calling the first file only. I tried to use a Do while Loop to include the second file but it completely fell over. The code is below Ideally I would like some ideas on how to...
  3. M

    Append two excel files to ms access table using VBA

    The second workbook is of the same layout but there may be a third one with a different layout later. However I would like to get this one sorted for now. The second file is in the same directory but called Contracts Maint.xls I don't understand Q2.
  4. M

    Append two excel files to ms access table using VBA

    This code works perfectly to append one excel file but I need help to amend it so it can append one file after another. Any ideas?
  5. M

    return value in an array for Excel

    No offence taken!
  6. M

    return value in an array for Excel

    Thanks very much for the code...I much prefer that and whats more it works! You are great!
  7. M

    return value in an array for Excel

    Hiya Thanks very much for replying but it didn't work. :-( Should I have put the formula in the B column? And I am trying to match the dates in the A column to the array. I need a formula that will return the correct period i.e. (07/08 P1 etc) that the date falls in.
  8. M

    return value in an array for Excel

    Hi Wonderful people. I have searched high and beyond but can't seem to find the correct answer to this issue. I have a list of dates (list 1) and by each date I want to put a formula in a cell that will search the array and return the period number I have a table which list (list2) an...
  9. M

    Help! Append query in VBA

    Can mods please delete this thread as it is a duplicate. I really wanted the question ans in the VBA section but posted it here by mistake. Sowwy!:o
  10. M

    help with append query in VBA

    Thanks, will that work in VBA...sorry for being such an nunce but I am quite new to this. What would the layout be like?
  11. M

    help with append query in VBA

    I have an excel file which I have linked to my access dabatase. I would like to link the tables to a table in my database using VBA so I can apply the code to a button and run it automatically as it is quite tedious having to do it every two weeks which is when the data is required. Most of...
  12. M

    Help! Append query in VBA

    I have an excel file which I have linked to my access dabatase. I would like to link the tables to a table in my database using VBA so I can apply the code to a button and run it automatically as it is quite tedious having to do it every two weeks which is when the data is required. Most of...
Back
Top Bottom