Results 1 to 1 of 1

Missing piece of code

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    scotland
    MS-Off Ver
    Excel 2007
    Posts
    1

    Missing piece of code

    Folks
    Complete newbie but have picked up so much reading previous threads, hopefully someone can help with the following.

    I have a master workbook which I control which when opened, opens another 10 protected workbooks and pulls over data that is collated in the master. The following extract carries out this task on one workbook.

    Workbooks.Open Filename:="C:\01.xls", Password:="ab"
        	Workbooks("01").Close SaveChanges:=False
    This works well and updates the master however I am then presented with a message box requesting I enter the password to open the above file “01”. Even though I press cancel the data is transferred as designed.
    Is there a way to switch off this request to fully automate the process of updating the master spreadsheet.

    Thanks
    Last edited by arlu1201; 08-02-2012 at 04:11 PM.

Thread Information

Users Browsing this Thread

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

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