Search results

  1. 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?
  2. 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...
  3. 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...
  4. 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