Results 1 to 7 of 7

VBA: saving workbook with password error

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Windsor, UK
    MS-Off Ver
    Excel 2007
    Posts
    43

    VBA: saving workbook with password error

    Hi All

    Hoping someone can help me out with an error i'm getting with this bit of code please

    When i try to run this code i get a "Named Arugument Not Found"

    
    
    
    Dim filepath2 As String
    Dim Filename3 As String
    
    filepath2 = "H:\Monthly MI\Excel_Suites\"
    Filename3 = CBfile & " v1" & ".xlsm"
    cbpass = "RRRP"
    
    ActiveWorkbook.SaveCopyAs Filename:=filepath2 & Filename3, Password:=cbpass
    Any help is greatly appreitated

    My thanks in advance!
    Last edited by Broobi; 10-08-2015 at 10:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove Workbook Password when Saving a Copy for Distribution
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2015, 04:51 AM
  2. Creating a new workbook, copying sheets & saving workbook - Subscript error
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2014, 09:04 AM
  3. Error 9 when saving workbook
    By 06nenglish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2013, 10:47 AM
  4. [SOLVED] password protect worksheets upon opening or saving a workbook.
    By emilyloz in forum Excel General
    Replies: 2
    Last Post: 06-14-2013, 03:14 PM
  5. VBA Run Time Error when saving workbook between Users....?
    By slu2383 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-28-2012, 04:22 PM
  6. Error Saving Protected Workbook
    By sdforson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2010, 10:44 AM
  7. HELP! Get error while saving after password protection
    By monica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2005, 06:35 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