Macro that should create csvs of all the sheets of a workbook doesn't work! help!

**scantron** · 06-15-2012, 10:48 AM

Please Login or Register  to view this content.

The line that is throwing an error is ".SaveAs Filename:="C:\8350\" & "8350" & "_" & w.Name & FileExtStr
.Close"

**vandan_tanna** · 06-15-2012, 12:15 PM

Here are changed I have made along with comments on why I made the changes.

Please Login or Register  to view this content.

Also, please ensure that you do have a directory called 8350 under C:\

**vandan_tanna** · 06-15-2012, 12:41 PM

redoing the code...

**vandan_tanna** · 06-15-2012, 12:46 PM

How about this one?

Please Login or Register  to view this content.

Please ensure that you have a directory named '8350' under C:\

Re: Macro that should create csvs of all the sheets of a workbook doesn't work! help!