Recent content by Craig.A

  1. C

    Define a non-continuos excel range with unknown amount of rows from aceess

    Thanks folks I am going to consider my approach over the weekend. I made some progress today with the team who are delivering the file. Turns out they do some manual manipulation before it is delivered to us so I am pushing back my ask on them to see if I can get the file nice and clean...
  2. C

    Define a non-continuos excel range with unknown amount of rows from aceess

    The source file will not be in a fixed location. I would like the user to browse for the file as before. Craig
  3. C

    Define a non-continuos excel range with unknown amount of rows from aceess

    Hi All I have tried to piece together a solution from numerous threads but have not solved my problem. I am trying to upload an excel range (non adjacent columns and unkown amount of rows) to an array. Up to now I have used the below which uploads the full sheet and I have manipulated the...
Top Bottom