Results 1 to 2 of 2

Overwrite write reserved file with updated copy (same name; also write reserved)

Threaded View

Henk Stander Overwrite write reserved file... 02-06-2014, 06:58 AM
Henk Stander Re: Overwrite write reserved... 02-13-2014, 08:38 AM
  1. #1
    Forum Contributor
    Join Date
    05-02-2012
    Location
    Mosselbaai, Suid Afrika
    MS-Off Ver
    Excel 2016
    Posts
    107

    Overwrite write reserved file with updated copy (same name; also write reserved)

    Overwrite write reserved file with updated copy (same name; also write reserved)

    Is it possible to use VBA to overwrite a file previously saved as read only with an updated copy (same name), also as read only?

    Also posted at the following due to user interface problems:
    http://www.vbaexpress.com/forum/show...431#post304431

    "Run-time error '1004': Operation failed. \\mgadmdat\public\Reliability & Engineering Services\Workshop and Fabrication Service\Fabrication\ISO 9001\Contractors Score Card\Archive\Fabrication Contractor Score Card (2011 - 2012).xls' is write reserved.

    I.e. "Operation failed. 'FullFileName.xls' is write reserved."

    I get this error when I am trying to overwrite the existing file with the following code:
    (Note: The code must also work when there are no previously saved copy)

    Dim NewBookName As String
    
    NewBookName = Range("FabConSCFFN").Value
    
    ActiveWorkbook.SaveAs FileName:=NewBookName, _
            FileFormat:=xlNormal, _
            PassWord:="", _
            WriteResPassword:=WagWoord, _
            ReadOnlyRecommended:=True, _
            CreateBackup:=False
    I appreciate your time,
    Best Regards

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Want to write a macro which will copy only updated data
    By ahsanzafar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2012, 03:38 PM
  2. Reserved by - Protected
    By Firyali in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  3. Reserved by - Protected
    By Firyali in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Reserved by - Protected
    By Firyali in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. Reserved by - Protected
    By Firyali in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

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