как задать к файлу в макросе VBA в Mac OS
Sub SaveSheet()
Dim ActiveSht As Worksheet
Dim NewWb As Workbook
Set ActiveSht = ActiveSheet
Set NewWb = Workbooks.Add
With ActiveSheet.UsedRange
ActiveSht.Copy Before:=Workbooks(NewWb.Name).Sheets(1)
End With
ActiveWorkbook.SaveAs Filename:="O:\QUOTATIONS\ " & "Q" & "_" & [R3C3] & "_" & "от" & "_" & [R3C5] & "_" & [R4C2] & "_" & [R11C2] & ".xls"
MsgBox "лист скопирован в новую книгу и сохранен в: O:\QUOTATIONS !", , ""
End Sub
Ошибка в этой строке:
ActiveWorkbook.SaveAs Filename:="O:\QUOTATIONS\ " & "Q" & "_" & [R3C3] & "_" & "от" & "_" & [R3C5] & "_" & [R4C2] & "_" & [R11C2] & ".xls"
Как правильно прописать путь?