Results 1 to 2 of 2

Thread: [2003] Excel+VBA: SaveCopyAs with password support?

  1. May 11th, 2007, 02:34 PM #1
    mariocatch
    mariocatch is offline

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    9

    [2003] Excel+VBA: SaveCopyAs with password support?

    Is there any way to use the SaveCopyAs function but with password support?

    I need to keep the template excel doc in-tact and unchanged. So I'm using SaveCopyAs and saving the updated version of the template xls doc to aonther location. But, when it's saved to that location I want to password protect it. Not sure of another way to do this without using SaveCopyAs, but I can't figure out a way to password protect with that function call.
    Last edited by mariocatch; May 11th, 2007 at 02:39 PM.
    Reply With Quote Reply With Quote
  2. May 11th, 2007, 02:58 PM #2
    mariocatch
    mariocatch is offline

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    9

    Re: [2003] Excel+VBA: SaveCopyAs with password support?

    Resolved, using using SaveAs instead.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width