Macro for Retrieving data from closed workbook with date in title

[DavidH56]

I've been able to get info regarding retrieving data from a closed workbook
using info from several of these threads but I've not had success retrieving
data from the most recent workbook located on my Project shared drive. The
closed workbook is password protected and has a date in its name.
(ie..//nnsrv045/LHD/Sched/Current/Event Listing 08-Apr-2008). I would like
to be able to retrieve data from the closed workbook column b and write it to
the active workbook to column j and retrieve data from the closed workbook
column e and write it to the active workbook current sheet column k. The
number of rows will vary in the closed workbook. Any help at all would be
greatly appreciated.

 

[Mark Ivey]

Just read something on the MS website...

http://support.microsoft.com/kb/257819

"You cannot open a password-protected Excel file as a data source."


"You Cannot Open a Password-Protected Workbook"

"If the Excel workbook is protected by a password, you cannot open it for
data access, even by supplying the correct password with your connection
settings, unless the workbook file is already open in the Microsoft Excel
application. If you try, you receive the following error message:
Could not decrypt file.
For additional information, click the article number below to view the
article in the Microsoft Knowledge Base:
211378 (http://support.microsoft.com/kb/211378/EN-US/) XL2000: "Could Not
Decrypt File" Error with Password Protected File "



Mark Ivey

 

[DavidH56]

Thanks Mark for replying. I'll read about this subject.