First of all, many many thanks for your response and willingness t
assist.

I am by no means an expert in VBA, thats for sure, but I went to ru
the macro from alt+F8, and the only thing available was tester. I ra
this, and I got a run-time error '3004'. It occurs on the lin
.savetofile spath ......

Any thoughts?

Second. If you get a second, would you mind going through some of th
lines of code and discussing why they are used and what they are doing
Based on what I know about VBA, I see three sub procedures, but as
mentioned previously, there was only 1 macro. Additionally, there ar
some objects and methods here that I have never seen. I guess, if yo
wouldnt mind, could you add some notes on how this macro was peice
together and what some of it is doing. To a fault, I learn by seein
the final product and trying to peice it together. With this code,
wouldnt even know where to start.

Lastly, what would you suggest as a text so I can learn this type o
programming? My interests lie in this kind of coding (controllin
other apps, data retrieval, data storage, data analysis).

Again, and as always, thank you for any assistance you can provide

--
Btiber
-----------------------------------------------------------------------
Btibert's Profile: http://www.excelforum.com/member.php...nfo&userid=855
View this thread: http://www.excelforum.com/showthread.php?threadid=53741