Export Specified Sheets to .csv file

[cow1234]

Long time reader, first time poster.

I am trying to create vba code that will allow me automatically export four different sheets in an excel workbook (.xlsm file to be exact) named, for example, SheetA, SheetB, SheetC, SheetD to individual .csv files saved automatically always on the desktop (and to replace any existing files of the same name). I would like the .csv files to be named after their sheet name.

I have searched tirelessly with no success. My problem when I try to record the macro (which I often do b/c of little coding experience) is that File > Save as... .csv changes my .xlsm file to the .csv and it just gets all messed up. So I am looking for something that will save these four sheets in the background without actually opening the .csv files.

Any suggestions?<textarea id="adlesse_unifier_magic_element_id" style="display: none;"></textarea>

 

[Joe4]

Welcome to the Board!

Why not store/run the code from a different Excel workbook?
If you open a new blank workbook, turn on the Macro Recorder, then open the file file you want, and save each sheet to a separate CSV, it should give you most of the code you need.

 

[cow1234]

That has potential, but creates another problem in that this file gets copied every month and changes files name. Is there anyway I could select the specific file to open in the new blank workbook?

I just have to make the solution as easy as possible for my end users (which are less computer literate than me).<textarea id="adlesse_unifier_magic_element_id" style="display: none;"></textarea>

 

[Joe4]

Here is some VBA code you can use to open the file browser so when they run it, it will prompt them to select the file they want to run it against: http://www.mrexcel.com/forum/excel-questions/557860-browse-file-excel-visual-basic-applications.html