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.
--
By persisting in your path, though you forfeit the little, you gain the
great.