VBA programmer mode in Mac excel 2016 Hi All Wondering if you can help i have just recently got excel for Mac the new office 2016 now when i use to work in the classic mode on a windows Pc the Alt f11 use to bring up the classic mode of VBA programmer with the tool bar at the top that use to allow you to insert user form and module forms etc. If you are a Mac user, you will now be able to write macros to help you automate Excel and save time with your job. If you are new to macros or want to learn more, checkout my upcoming free webinar on The 7 Steps to Getting Started with Macros & VBA.
I have a Form I have my company use and some users use Macs but most use PC. The VBA below works 100% fine with PC users but since Mac's have a few different variances when it comes to File Path's I'm running into an issue of them using my form to save the file when clicking a button assigned with VBA. Please note that I am trying Application.OperatingSystem code on Lines 37 and 94 but for some reason it still runs the entire code for Mac users while completely ignoring my If Statement for Operating System and reads it as PC Here's what I have currently have. Code: Sub SaveAndEmailAcquisition Dim OutApp As Object Dim OutMail As Object Dim StrBody As String Dim StrTo As String Dim StrSubject As String Dim StrAtt As String Dim StrSignature As String Dim strGenericFilePath As String: strGenericFilePath = ' corp.company folder1 folder2 folder3 ' Dim strOSGenericFilePath As String: strOSGenericFilePath = '/Documents' Dim strFileName As String: strFileName = Sheets('Acquisition').Range('AcquisitionTitle') & ' Acquisition Request Form' ' Creates Message Box asking if Form has been complete.
![Mac Mac](https://i.stack.imgur.com/Vq6we.png)
If not, it cancels code to continue MSG1 = MsgBox('Have you filled out EVERY box of information on this form?'