+ Reply to Thread
Results 1 to 6 of 6

Catalina not letting me save via VBA

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    New Zealand
    MS-Off Ver
    Microsoft Excel 2019
    Posts
    8

    Catalina not letting me save via VBA

    Hi all,
    A slightly unusual problem. I have just done a clean install of Catalina, and have purchased Excel 2019 for Mac. I'm using a "late 2015" iMac with 32GB of RAM.

    I have a Macro which I have been using for years, but which now falls over on this line:

    Please Login or Register  to view this content.
    ...with a Run-time error 1004: Method 'SaveAs' of object 'Workbook' failed.

    I get the same error if I replace the file type with an xlsx file, format xlOpenXMLWorkbook.

    The silly thing is, if I have previously (in the same session) manually saved the file, then the macro runs and saves the file as it should.

    I figure it's some sort of permissioning in Catalina, but I have permissioned the folder both for "me" and "everyone" to Read & Write.

    Having spent some time thinking about it, I thought I had hit upon the answer by giving Excel "Full Disk Access" in Security & Privacy Preferences, but this didn't make any difference either.

    I'm sorta bereft of ideas now. Does anyone have any others?

    Thanks

    Phil
    Last edited by alansidman; 11-29-2019 at 08:53 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    16,322

    Re: Catalina not letting me save via VBA

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

  3. #3
    Registered User
    Join Date
    06-27-2014
    Location
    New Zealand
    MS-Off Ver
    Microsoft Excel 2019
    Posts
    8
    My apologies, and thank you.

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,606

    Re: Catalina not letting me save via VBA

    Hi
    your profile indicates XL2007 and your question is about a Mac version.
    Which is correct?
    What or who is Catalina?
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  5. #5
    Registered User
    Join Date
    06-27-2014
    Location
    New Zealand
    MS-Off Ver
    Microsoft Excel 2019
    Posts
    8
    Quote Originally Posted by Pepe Le Mokko View Post
    Hi
    your profile indicates XL2007 and your question is about a Mac version.
    Which is correct?
    What or who is Catalina?
    Sorry, Catalina is the new 64-bit-only MacOS, necessitating the need to upgrade Excel (and other 32-bit apps) to the 64-bit version.
    I have updated my profile.

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,635

    Re: Catalina not letting me save via VBA

    Welcome to Apple's sandboxing. You should be seeing prompts rather than VBA errors, but that might be a Catalina-specific problem. There is a new VBA method for allowing access to external files: https://docs.microsoft.com/en-us/off...omultiplefiles
    Rory
    Days when we raged, we flew off the page
    Such damage was done

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1