Reply to thread

Message: [QUOTE="DavidH56, post: 6311611"] 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. [/QUOTE]