Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Replacing modules with code (VBA/Word-Excel/2000)

    Further to <post#=452257>post 452257</post#>, Given the following initial situation:

    1. <LI>Workbook TARGET is open
      <LI>The VBA code within TARGET is locked for viewing; and the password is known
      <LI>TARGET contains approximately 25 modules, one which we'll call REPLACEMENT needs to be replaced
      <LI>Workbook SOURCE is open
      <LI>SOURCE contains the operating code I need to develop
      <LI>SOURCE also contains the new version of REPLACEMENT module
    I have been unable to get started with code to achieve the following.
    1. <LI>Unlock TARGET VBA code for viewing, using the password
      <LI>Remove REPLACEMENT module from TARGET project
      <LI>Copy REPLACEMENT module from SOURCE project to TARGET project
      <LI>Lock TARGET VBA code for viewing, using the password
    Can someone please provide guidance?
    Regards
    Don

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing modules with code (VBA/Word-Excel/20

    Part of your solution is given in http://www.standards.com/index.html?...rojectPassword.

    The remainder of yiur solution would likely use similar techniques,

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing modules with code (VBA/Word-Excel/2000)

    Don,

    Try this <!post=link,466581>link<!/post> .

    Regards,
    John

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Replacing modules with code (VBA/Word-Excel/2000)

    John
    Thanks for the input; I only hope that I develop sufficient understanding to use it properly.
    Regards
    Don

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing modules with code (VBA/Word-Excel/20

    Don't use SEndKeys.

    See the link I posted.

    http://www.standards.com/index.html?...rojectPassword

Posting Permissions

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