Search results

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...

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...