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!
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!
Code:
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
Last edited:
