So working with your suggestions and with some of the links you've provided, I was able to make a little bit of progress. I was able to record the macro using the "Import External Data" as you suggested, and I think that this will probably work out for what I want to do. However, I'm trying to clean up the code, using something you suggested in one of the other posts, and now I'm getting an error message. here is my code.
Originally Posted by MSP77079
Now, Everything is the same as was recorded except for the begining, where I'm trying to use that "FirstArray" string. I'm just trying to clean up that begining part. However, when I do this, I get an error reading "Incomplete Datasource" when the code comes to ".Refresh Background Query:=false".
Any idea? Am i just missing something? Oh yea, here is the code that I recorded that actually works.
Any help is much appreciated.