I need some vb code that I could perhaps run from access that will look
in a particular folder I could specify in the code, and convert all the
files (just excel are saved there) to .csv. Is this possible? This
would be a huge help for me and any help would be greatly appreciated.


Also, there are only 5 files in the folder (the folder path never
changes) but they are updated monthly so if we cant evaluate the entire
population that is in the folder and have to write seperate code to
convert each file that is cool too.

Here is my process:

Excel Files Updated and saved to directory --- Saved as csv in same
directory--- Imported in Access --- Access Reports Runs ---Done

I would love to have all this done in a click of a button, im so close
I just need to get this conversion to csv piece.

Thanks.