Filelen Command

I've recently upgraded my old 17" MBP which was very happily running Office Mac 2011

In the process of transferring files from the old Mac to the new MBP 15" my 10 year old MAC got the white screen of death.

Im now having to fast track one of my packages to Office 365 (Excel 2016)

Already I'm not happy as it seems Userform no longer exists does anyone know if there is a list of functions etc that has changed between office 2011 and 365 with respect to VBA?

Today I found that Filelen does not seem to function I understood the the delimitation was by : eg

Lresult = FileLen("Macintosh HD:Users:mdj:Documents:office:test.docx")

This structure worked ok in 2011 but not now

Thank you for your help


 

Question Info


Last updated October 18, 2019 Views 351 Applies to:
Answer
Answer

Hello Lux,

I tested FileLen. The value returned for me is always zero. This is a bug. FileLen is in the object browser and should work.

To report this problem, click the Smile button in the upper right corner of Excel's window.

The Visual Basic Editor (VBE) in Office 2016 and Office 2019 lacks the ability to make and edit userforms in the GUI. Userforms made in other versions of Excel will work and can be imported using File > Import assuming they were exported from a working version of Excel's VBE using File > Export.

I don't know of a comprehensive of list of changes, I can tell you that there is support for many new features that weren't in 2011 and earlier versions. The lack of UserForm support is a problem that Microsoft has not yet addressed.

Enable VBA Support for creating and editing UserForms (not the Data Form)

You can program Office 2019 using AppleScript, JavaScript or Objective-C.

I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer

Heh -- you aren't supposed to be able to see the Insert Userform command or the (partially working) editor yet. :) That's a work in progress and is still unsupported; it is supposed to be visible only to Microsoft engineers at this point, not to the public.  Sorry for the confusion.

As for FileLen(), I'll take a look. It should work. Note that in Office 2016 and later, Mac paths are delimited by "/", not by ":", as we're now following the (modern) macOS conventions that use a unix forward-slash instead of the deprecated HFS colon.

Schwieb

Principal Software Engineer

Office for Apple Platforms

Microsoft Corporation

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.