Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help unprotecting workbook before importing
I'm trying to import a workbook into an open workbook using the code below, however, the workbook I'm trying to import has a password. The password is blank (essentially no password). Sheets.Add Type:= "E:\mattw\My Documents\My Timesheets - 2006.xls" So.... since it's "password protected" with a null password, how can I unprotect the workbook BEFORE importing it?? Do I have to open it, then remove the protection, or can I remove the protection while I'm inserting it? Thanks in advance! Matt W -- BVHis ------------------------------------------------------------------------ BVHis's Profile: http://www.excelforum.com/member.php...fo&userid=8593 View this thread: http://www.excelforum.com/showthread...hreadid=502238 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help unprotecting workbook before importing
Maybe you could just open the workbook, steal a copy of the worksheet and close
that workbook: Option Explicit Sub testme() Dim wks As Worksheet Dim curWkbk As Workbook Set curWkbk = ActiveWorkbook Set wks = Workbooks.Open _ (Filename:="c:\my documents\excel\book3.xls").Worksheets(1) wks.Copy _ befo=curWkbk.Worksheets(1) wks.Parent.Close savechanges:=False End Sub BVHis wrote: I'm trying to import a workbook into an open workbook using the code below, however, the workbook I'm trying to import has a password. The password is blank (essentially no password). Sheets.Add Type:= "E:\mattw\My Documents\My Timesheets - 2006.xls" So.... since it's "password protected" with a null password, how can I unprotect the workbook BEFORE importing it?? Do I have to open it, then remove the protection, or can I remove the protection while I'm inserting it? Thanks in advance! Matt W -- BVHis ------------------------------------------------------------------------ BVHis's Profile: http://www.excelforum.com/member.php...fo&userid=8593 View this thread: http://www.excelforum.com/showthread...hreadid=502238 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help unprotecting workbook before importing
Can I copy multiple worksheets in one shot doing it that way, or would I have to copy 1 worksheet at a time?? Matt W -- BVHis ------------------------------------------------------------------------ BVHis's Profile: http://www.excelforum.com/member.php...fo&userid=8593 View this thread: http://www.excelforum.com/showthread...hreadid=502238 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotecting Workbook | Excel Discussion (Misc queries) | |||
why do I get a warning when unprotecting a workbook | Excel Worksheet Functions | |||
Unprotecting not working in Shared workbook | Excel Programming | |||
Protecting/Unprotecting Workbook | Excel Programming | |||
unprotecting workbook | Excel Programming |