Hi Guys,
Thanks for reading my query.
I have written some procedures in VBA Excel on my win 10 laptop. But these procedures are intended to be used by some mac laptop users as well and they are facing error at this particular statement highlighted in red.
But this works fine in windows laptops.
temp1 = ThisWorkbook.Sheets("EVALUATION DETAILs").Range("F4").Value
temp2 = ThisWorkbook.Sheets("Wlcm Note").Range("G5").Value
Path = ThisWorkbook.Path
Msname = "Mystery_Shopper_" & temp1 & "_" & temp2
Application.DisplayAlerts = False
ThisWorkbook.SaveAs FileName:=Path & "" & Msname & "_" & Format(Now(), "DD-MMM-YYYY hh mm AMPM") & ".XLSB", FileFormat:=50
Thanks so much in advance.
Thanks for reading my query.
I have written some procedures in VBA Excel on my win 10 laptop. But these procedures are intended to be used by some mac laptop users as well and they are facing error at this particular statement highlighted in red.
But this works fine in windows laptops.
temp1 = ThisWorkbook.Sheets("EVALUATION DETAILs").Range("F4").Value
temp2 = ThisWorkbook.Sheets("Wlcm Note").Range("G5").Value
Path = ThisWorkbook.Path
Msname = "Mystery_Shopper_" & temp1 & "_" & temp2
Application.DisplayAlerts = False
ThisWorkbook.SaveAs FileName:=Path & "" & Msname & "_" & Format(Now(), "DD-MMM-YYYY hh mm AMPM") & ".XLSB", FileFormat:=50
Thanks so much in advance.
Last edited: