Hi,
Strange situation, but yesterday my vba worked perfectly but today the query stops when it comes to the moment it has to save a file...
So I have one file and it should copy one sheet from that to a new workbook and save it as csv file...The part of that code is...
ActiveWorkbook.SaveAs FileName:= _
"/Volumes/GoogleDrive/My Drive/blabla Inc/Audit/Audit automatizacija/CR before paypal.csv" _
, FileFormat:=xlCSV, CreateBackup:=False
Error is 1004 cannot access read only file CR before paypal.csv but I can't figure out what is readonly when i am not opening and changing any file but saving the new one...
Previous to this it succesfully do exact thing but saving xls file error is only with this csv but it has to be csv file...
Bookmarks