mac

  1. P

    Export as PDF Loop maxes out at 21 iterations

    Trying to implement this code to a loop in Excel for Mac 365: Sub SaveReportAsPDFIn2020() Application.ScreenUpdating = False Application.EnableEvents = False 'Ben Matson : 5-June-2020 'Test macro to save as pdf with ExportAsFixedFormat Dim filename As String Dim...
  2. A

    VBA/Macro "Return to most recent worksheet"

    I have a macro I want to iron out... I need to copy/paste specific columns from one work sheet to another. I believe I have it to where when I run the macro, it will successfully copy/paste the columns. My problem is the way I wrote the macro, it only knows to do it between two certain...
  3. S

    HELP with data delimiters

    Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...
  4. L

    Can Excel VBA Windows run on Mac and vice versa?

    I have lots of Excel VBA applications developed on PC for the Windows platform (over the past 20 years). I have lots of trouble recently after Windows update - system very very unstable. I am thinking of ditching the Windows completely, and move all my development to iMac. Question: 1. Can...
  5. M

    Updating values and highlight them based on external excel file

    Hey guys I have two versions of the same files. One of them is the updated one with the new data. Now I have troubles writing a macro which does the following: Ask which file I want to compare it to. Comparing two identification numbers in those two different files. If they match, it shall...
  6. O

    Using MacScript with VBA to pull a file name

    Hi All and TIA, I'm trying to use VBA to launch a file picker and save the file name that the user selects in a certain cell (on a Mac - msoFileDialogFilePicker isn't compatible). I managed to do this with the file path using the code below. However, I found the MacScript command on google and...
  7. M

    Using the Macscript function to download and rename a file.

    I couldn't get this sub to work so I've made some changes to it but I no longer have access to a MAC to test on. Can someone test this for me or tell me a way of downloading and renaming a file and then specifying its path while on MAC...
  8. M

    How to get GMT time on MAC with vba.

    Currently using the following on Windows to get GMT/UTC time but I need a way of doing this on MAC as well. Thanks in advance. Function UTC() As Date Dim dt As Object Set dt = CreateObject("WbemScripting.SWbemDateTime") With dt .SetVarDate Now UTC = .GetVarDate(False) End With...
  9. M

    How to download a ZIP file and access its contents while on MAC.

    I'm aware that I can use activedocument.follow hyperlink to download a file given a URL, but I'm unsure of how to interact with that file after it has been downloaded. Is it possible to rename the file upon download or specify where the file is downloaded to using VBA? Furthermore, how can I go...
  10. M

    Maintain text qualifier while creating a Web Query on MAC

    There's a Web Query in my workbook created on Windows that doesn't work if the workbook is opened on MAC and results in an error if trying to refresh it via vba and does nothing otherwise. I came across a variant of the following code on stack overflow which works to import the data from the...
  11. S

    Excel for Mac - Visio ad-in does not work

    I just upgraded my software to 16.29.1 for Mac. The release notes tout a new Visio ad-in for excel. I loaded it from the store and it just show me a blank rectangle when it is supposed to have functionality. Anyone else having this issue? FYI, I am logged in to my O365 license (although...
  12. H

    Restrict User From Interrupting Macro

    Hello Friends, I am using the below code which is linked with Workbook open event Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic Call show_index_sheet Sheets("INDEX").Unprotect Password:="merchant" Sheets("INDEX").Range("A1").Value = GetMACAddress() If...
  13. H

    Open File If MAC Address Matches With That Mentioned In The Code

    Hello Friends, Is it possible to Open a file only for specific computers. A VBA code for let’s say 3 MAC Addresses is linked with Workbook Open Event & the file should open for those 3 computers who’s MAC Addresses are there in the code - otherwise a msg box should prompt saying that you are...
  14. E

    Sheet Compatibility

    I have a .xls spreadsheet with macros. The macros run perfectly in Windows 10 Office Excel 16 but not in Office Excel 2019 for MAC. Do I have to convert this sheet to run the macros properly in Office Excel 2019 for MAC?
  15. I

    VBA to copy to clipboard on MAC?

    I have Excel 2019 (16.29.1) I do not see an option to insert a userform or enable object library 2.0. Is there a way in Excel for Mac to setup a macro to copy cell value to clipboard? Thanks for the help!
  16. C

    What is the mac equivalent of ctrl+j in the text to columns wizard?

    I'm writing a macro and one of the steps involves splitting multiple rows in one cell into their own separate rows. What is the equivalent of hitting ctrl+J in the text to columns wizard? I've already tried ⌘+J, ^+J, and ⌥+J, but those aren't working. If anyone knows of a chart that lists the...
  17. S

    VBA - store value after Excel closed and retrieve value when reopened

    Can anyone help with this please? I want to extract the MAC address (used for IP) then store this value after Excel is closed down. On reopening I'd like to check that the previously stored MAC address = the current MAC address. Ideally I'd like this to work in an Add-In xlam rather than an...
  18. TAPS_MikeDion

    VBA 2011 for Mac (ver 14.0) - Screwed up userform scroll bars

    Hello everyone, Is there something I'm doing wrong with trying to add scroll bars to my userform? As per the title, I'm using VBA for Mac 2011 and I can't seem to get the scroll bars to work. I can only double-click them to get them to move. There aren't even arrows to click on. What the ...
  19. M

    How to suppress compile errors generated from ActiveX code being present on MAC

    I have a workbook with code referencing activex objects that isn't supposed to be ran on if the user is on Mac, however after the user gets out of the initial read only mode upon receiving the document, ActiveX objects are deleted. Trying to run certain macros will then result in compile errors...
  20. A

    Apple Mac File Path

    Hi all, I'm working on a spreadsheet for a friend who uses a Mac. I have zero experience on a Mac so I'm hoping I could get some help please. The below code works on my PC but it fails on his Mac: Sub ImportRawReport() Application.ScreenUpdating = False Sheets("RawReport").Select...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top