File Save as not working

[jm13]

Hi, I have probably a very simple question. When I click "File Save As" nothing happens when using excel in my MacBook Pro. I have no issues when using my other computer (Dell work computer).

Any suggestions? Thanks.

 

[rollis13]

Since you are using SaveAs you probably are 'building' the path. Mac uses / as folder-separator against \ with Windows.
Change your macro to test your Operating System in use and add an If/Then/Else to manage the right folder-separator.

 

[jm13]

Since you are using SaveAs you probably are 'building' the path. Mac uses / as folder-separator against \ with Windows.
Change your macro to test your Operating System in use and add an If/Then/Else to manage the right folder-separator.

Thanks for your response. Can you expand on what you mean by "Change your macro"?

 

[JEC]

If it's true what Rollis is saying then something like this

Sub jec()
 c00 = "C:\Users\xxx\Downloads\abc.xlsm"
 
 If Application.OperatingSystem Like "Mac*" Then
   ThisWorkbook.SaveAs Replace(c00, "/", "\"), 52
 Else
   ThisWorkbook.SaveAs c00, 52
 End If
End Sub

 

[jm13]

If it's true what Rollis is saying then something like this

Sub jec()
 c00 = "C:\Users\xxx\Downloads\abc.xlsm"
 
 If Application.OperatingSystem Like "Mac*" Then
   ThisWorkbook.SaveAs Replace(c00, "/", "\"), 52
 Else
   ThisWorkbook.SaveAs c00, 52
 End If
End Sub

HI, appreciate your help. This is beyond my "expertise" level. I was hoping the answer would be to click a box somewhere in settings, etc. I'll probably take your initial suggestion. Thanks again.

 

[JEC]

If you are not specifying the path in VBA, Save as should work properly on a mac too. Weird issue

 

[Fluff]

What makes you think the OP is using a macro? He/She said

When I click "File Save As"

Which to me suggests not macros.

 

[rollis13]

Because He/She probably would have said: click menu "File" click "Save As..." but maybe Mac is different.