Share via

Opening a file using the Macro Open function

Anonymous
2015-11-11T22:10:26+00:00

Since I upgraded to El Capitan the Excel macro script I have used for years now only opens files Read Only.  I've verified that the Open function calls do not specify read only.  If I open the files without using a macro script they open Read/Write.  Does anyone have any suggestions on how to open the files read/write using a macro script?

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2015-11-16T16:44:26+00:00

    I wasn't pointing you to the 2016 information so much because of 2016, but because El Capitan has file restrictions that earlier versions of Mac OS X don't have. 

    When it comes to using Macros in El Capitan we have to do trial and error to see what works and what doesn't. I don't know of a resource to point you to that has elaborate details about what to expect and how to go about updating file related macros. One thing to keep in mind is the length of the file path. Keep it short.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-11-14T22:35:41+00:00

    The version of excel I am having a problem with is v2011 not v2016.  Also, I'm not using VBA but the older macro language from previous versions (The reference book I have is from 1991!!).  I haven't gotten around to converting them to VBA.  I was hoping to avoid converting to VBA.

    Was this answer helpful?

    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2015-11-14T21:09:20+00:00

    Hi

    I deleted Joe's answer. He simply has no clue about what it is you are talking about.

    This territory has been covered in a previous question. Click here and read through the thread for the information you need:

    File finding problems in 2016 mac preview for Excel ...

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more