Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected -

1. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular file directory.

2. I don't want these worksheet names to change nor the workbook name to change.

3. The file-name is consistent for each worksheet, so it would be okay to replace the files in the directory whenever I run the macro. Its okay to have a dialog box that asks if I'm sure I want to replace each of the files.

4. I don't want the newly created CSVs or any other file to open.
--

Please Login or Register  to view this content.

'Sheets to CSVs
Here's a macro for exporting all sheets in an Excel file each to their own CSV file.

Sheets to CSVs

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

I just ran the macro in post #4 on a test workbook of my own, no edits, and it saved several CSVs into the noted folder.

Let's see your edited version, make sure the fPATH has a \ at the end ....

I did include the "\" at the end but for some reason it is still not working. If it helps, I'm using a Macbook. Do I need to input my own information in any parts other than the fPATH?

I don't really have much Mac experience. I'm pretty certain Macs don't use \ for path separators, probably colons :

don't work in mac environment as well but here's a link with someone how has mac coding examples
http://www.rondebruin.nl/mac/section3.htm