. Post titles to your problem. Provide in your post.
![]()
Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. Many of the shortcuts that use the Ctrl key on. Keyboard Differences Mac and PC keyboards are subtly different. Keyboard shortcuts that involve the Alt key in Windows use the Option key on the Mac.
Use the for non-questions. Only text posts are accepted; you can have images in Text posts.FAQ.Was your problem solved?OPs can (and should) reply to any solutions with:This will award the user a and change the post's flair to solved. To apply code formatting Use 4 spaces to start each lineYou can select code in your VBA window, press Tab, then copy and paste into your post or comment.
Provide your dataInclude a or use the website to generate the reddit table markup from your spreadsheet.Congratulations and thank you to these contributors DateUserCPA community since March 11, 2009 Download the official to convert Excel cells into a table that can be posted using reddit's. I have a Form I have my company use and some users use Macs but most use PC.
![]()
I read that Office 2016 for Mac changed how the output of Application.OperatingSystem. That said I'm surprised it would start with a 'W' and trigger the first IF statement. If you have access to any of these Macs causing problems you should be able to just msgbox/debug.print Application.OperatingSystem and check the result, as well as step thru the code with F8.that is perhaps more reliable, note you check for Mac first and then use the 'else' branch for Windows - there is a simple TRUE/FALSE constant for Mac environments, while Windows is broken down into Win64, Win32, etc. Based on what the article said, I made the following modifications. I also took out all the folder creating code for PC users as it was causing an error for Mac users.Mac users are now getting a 'Compile Error: Can't find project or library' which I gather is because it was trying to read the PC FilePath which is what I'm trying to get Mac users to not read but instead save on their Desktop as detailed on the OS FilePath String. Here is what I have now: Sub SaveAndEmailAcquisitionDim OutApp As ObjectDim OutMail As ObjectDim StrBody As StringDim StrTo As StringDim StrSubject As StringDim StrAtt As StringDim StrSignature As StringDim strGenericFilePath As String: strGenericFilePath = 'corp.companyfolder1folder2folder3'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. If not, it cancels code to continueMSG1 = MsgBox('Have you filled out EVERY box of information on this form?'
I had one of my colleagues test it on her Mac and she just sent me what the error said. I'm fairly certain it's because it's running the PC FilePath (StrGenericFilePath) instead of the OS FilePath (OSGenericFilePath)With that said, that means the #If Mac Thenisn't working. I can't see anything else that would cause this error on a Mac as the whole code runs flawless on a PC but the only difference between the two are how the FilePaths are read since Macs have a different FilePath system.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |