Feedback by UserVoice

Annemarie Honegger

My feedback

  1. 1,459 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    411 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for all your votes and comments about enabling support for UserForms in Excel for Mac.

    With emphasis on enabling more and more capability using Office add-ins in Excel that will work across platforms, we don’t expect to add support for creating and modifying UserForms.

    Please see this article for more information about what you can do in Excel with Office add-ins.
    https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview

    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    As a peaceful person, I make it a policy not to (openly) attribute to malice that can be explained by mere stupidity and negligence, especially when addressing an entity I am somewhat dependent on. I occasionally had positive responses to bug reports I submitted, but mostly not.

    I have access to a Windows system through a remote desktop connection, and at times had had a windows installation under Parallels. Dual boot is not an option since much of my main work is done with academic programs running under UNIX, which I mostly can run natively on my Mac without any hassle thanks to the efforts of the SBgrid consortium (https://sbgrid.org).
    Why should I not complain when MS sells to Mac users a product that is flawed?

    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    I won't directly accuse MS of intentionally introducing flaws in Office for Apple products, but they surely seem to be quite neglectful when it comes to their support for the MacOS version. Of course, historically the Mac was first: "Prior to packaging its various office-type Mac OS software applications into Office, Microsoft released Mac versions of Word 1.0 in 1984, the first year of the Macintosh computer; Excel 1.0 in 1985; and PowerPoint 1.0 in 1987. (https://en.wikipedia.org/wiki/Microsoft_Office). Nowadays, Office updates for Mac usually are released a year after the corresponding Windows versions are released. I started using vba as soon as it became available, to write macros that facilitate data visualisation of the results of the numerous bioinformatics programs that I have number crunching on either a large Linux cluster or, for smaller tasks, on six of the eight cores of my iMac (Excel does not make use of these). When MS announced that they would no longer support vba in Office2008 for Mac, I had to send out an urgent alert to all those using my macros: Do not update!!!. Apparently, a sufficient number of other Mac users had similar problems, relying on various add-ins and extensions that were no supported, so MS had to re-introduce VBA in Office 2011. But that they have released ever since is very buggy -Why is there a find/replace option in the menu of the vba editor, if it opens the correct dialog but does not do anything? If you leave the macro module of a user interface open when you save the workbook in windows, you can edit it on the mac, but you cannot switch between the graphical view and the macro view. Why does "Application.PathSeparator" return an obsolete value that no longer matches the one used in the path returned by "Application.ActiveWorkbook.Path"? At least they fixed the atrocious way they in the 2016 version placed the sandbox you needed to place programatically read and write files in a folder hidden deeply in the "system" folder, a hidden folder where you definitely do not want common users to start changing things around. And why, oh, why, do they have to associate any Xribbon customization to the individual workbook, when where is no equivalent to the "Custom UI Editor" for OSX. While I have altered the macros that up to Office 2004 added custom menus to the top of the screen (thanks, Ron de Bruin https://www.rondebruin.nl) to generate the xml code for the Xribbon and the callback routines, I still have to use Windows to attach the XML code to a template file, or to update the Xribbon for an existing file that is no longer in sync with the growing macro collection.

    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    The video you liked to shows how to create a Userform under Windows - this no longer works properly under EXCEL for Mac OSX

    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    You can use existing Userforms on Mac - however, it is no longer possible to create and edit them on the Mac, which is rather annoying.

    Annemarie Honegger supported this idea  · 
  2. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  3. 25 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Excel for Mac  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  4. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  5. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger shared this idea  · 
  6. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  7. 26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    I agree, there is no conceivable reason while text file import should be restricted to the *.txt extension. Under vba, "line input" is still possible, while the "Workbooks.OpenText" is similarly broken.

    Annemarie Honegger supported this idea  · 
  8. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  9. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  10. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger supported this idea  · 
  11. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    In EXCEL 2019 Mac, you jump to the rightmost or leftmost tab by pressing the command key while clicking on the arrow

  12. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger shared this idea  · 
  13. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Annemarie Honegger shared this idea  · 
  14. 23 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Annemarie Honegger commented  · 

    For users who use EXCEL in a scientific context (bioinformatics) this change is extremly limiting, as the ASCII text files generated by countless UNIX programs use the file extention to indicate the type of data contained in the text file.

    The windows version of EXCEL2019 allows to enter other extensions in the File name field of the "Open File" dialog, while at the same specifying a text file. Why can't the window version do the same

    Also, probably linked, under visual basic, "Workbooks.OpenText" seems to be similarly broken, pretending that the file does not exist, while "line input" works fine with exactly the same list of filepaths, filenames and extensions

    see:
    https://answers.microsoft.com/en-us/msoffice/forum/all/importing-ascii-text-files-with-extensions-other/9a0893c4-0412-4a0f-8fc9-b291971320c9

    Annemarie Honegger supported this idea  · 

Feedback and Knowledge Base