I have a very simple macro. I essentially get a data dump monthly for a club I volunteer for of the active members. I create several separate xls workbooks from that file which I then need to convert to .csv

Here is a sample of the code:

```
' convert Poker

Workbooks.Open fileName:= _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/xlsx/Poker.xlsx"
ChDir _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/csv"
ActiveWorkbook.SaveAs fileName:= _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/csv/Poker" & 
".csv" _
, FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Saved = True
ActiveWindow.Close

' convert Potluck

Workbooks.Open fileName:= _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/xlsx/Potluck.xlsx"
ChDir _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/csv"
ActiveWorkbook.SaveAs fileName:= _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/csv/Potluck" & 
".csv" _
, FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Saved = True
ActiveWindow.Close

' convert Pub_Night

Workbooks.Open fileName:= _
"/Users/birdsdeanger/Documents/CLUB/CSV
Files/Current_Month/xlsx/Pub_Night.xlsx"
ChDir _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/csv"
ActiveWorkbook.SaveAs fileName:= _
"/Users/birdsdeanger/Documents/CLUB/CSV Files/Current_Month/csv/Pub_Night" &
".csv" _
, FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Saved = True
ActiveWindow.Close

```

I run this section of the macro and get the following error:

[![sample error msg](https://i.stack.imgur.com/gamlv.jpg)](https://i.stack.imgur.com/gamlv.jpg)

If I abort the macro at this point, and manually save-as the csv file into the correct directory, and subsequently delete it and run the macro again... the macro will create the csv in the right directory (poker) and bomb out on the next save as (potluck). 

I'll repeat the process with the second file (potluck) (manual save as csv, delete the file from the directory) run the macro again and the first two file are created just fine, and it will bomb out on the third (pubnight)...

Any suggestions as to what is going on or how I can fix the code? I have to create 18 of these files monthly and I'd like to work the bugs out of my automation so I don't tear my hair when I run this crazy thing.