Recent content by chrism84

  1. C

    Looping through files in a directory

    Ahh excellent! Thank you very much :)
  2. C

    Looping through files in a directory

    Hello, I was wondering if someone could help me... I'm trying to loop through files within a directory, but my code doesn't seem to move past the first file. I've read that to move to a next file you could just input "myfile = dir". It doesn't seem to work here. I've pasted the code below, I'd...
  3. C

    using arrays in access

    Disregard my last post; working now. Thank you very much! :)
  4. C

    using arrays in access

    That's great, thanks! One more slight problem has arisen from this however; when i close the quotes after "INSERT INTO " i get a msgbox "Syntax error in INSERT INTO statement". Any idea why this would be? Thanks, Chris
  5. C

    using arrays in access

    I'm quite new to vba, and was looking for some assistance in retrieving values from an array. I was planning on making an array to store table names, then run an update query which will loop for all the tables in the array. My current code to test the array is: Sub ImportSchemaTable() Dim...
See more
Back
Top Bottom