Mac excel: saving a .csv with a set filename & the text in two different cells

[jlal1990]

Hi guys,

Posting a lot on here so thanks for your help.

The title should explain it all. I have a file name 'Growbots CSV' which i want all files to retain, but i would also like to add the values from two different cells to that text. the cells contain the words 'Film' (cell 1) and '50k' (cell 2). Currently this is what i have for just adding the filename, so if there is a way of adapting the code in a mac friendly way id be really grateful for your thoughts!

Sub GBcsv()'
' Makes a copy of the sheet as a CSV file and makes a new file called Growbots CSV.csv
'


'
    Sheets("Growbots Ingestion").Select
    Range("A1").Select
    Sheets("Growbots Ingestion").Select
    Sheets("Growbots Ingestion").Copy
    ChDir "/Users/joshualally/Documents/SALES DATA/DATA DUMP/"
    ActiveWorkbook.SaveAs FileName:= _
"/Users/joshualally/Documents/SALES DATA/DATA DUMP/GrowBots CSV.csv", _
        FileFormat:=xlCSVUTF8, CreateBackup:=False
    ActiveWindow.Close
    Range("A1").Select
    Sheets("Functions").Select
End Sub