+ Reply to Thread
Results 1 to 2 of 2

Error 1004 while save as file

  1. #1
    Registered User
    Join Date
    01-27-2016
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    22

    Error 1004 while save as file

    Hi,

    Strange situation, but yesterday my vba worked perfectly but today the query stops when it comes to the moment it has to save a file...

    So I have one file and it should copy one sheet from that to a new workbook and save it as csv file...The part of that code is...

    ActiveWorkbook.SaveAs FileName:= _
    "/Volumes/GoogleDrive/My Drive/blabla Inc/Audit/Audit automatizacija/CR before paypal.csv" _
    , FileFormat:=xlCSV, CreateBackup:=False


    Error is 1004 cannot access read only file CR before paypal.csv but I can't figure out what is readonly when i am not opening and changing any file but saving the new one...

    Previous to this it succesfully do exact thing but saving xls file error is only with this csv but it has to be csv file...

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Error 1004 while save as file

    A assuming you would require the full folder location

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] error 1004 - unable to save file
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2017, 07:16 AM
  2. Run-time error 1004 error on Mac only Application.Get.Save.AsFilename
    By Carpinteria Al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2016, 11:20 AM
  3. Error 1004 when trying to save file with name generated from cell value
    By Terios1951 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2015, 04:49 PM
  4. Runtime error 1004 when trying to save file via VBA
    By avh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2015, 03:20 AM
  5. [SOLVED] Run-time error 1004/Save file macro
    By egglee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2013, 06:22 AM
  6. Error 1004 with save button
    By koconn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2013, 09:55 AM
  7. SaveCopyAs Runtime Error 1004 - save a backup without altering open file
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2013, 08:11 PM

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