Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 173
Default Managing a picture folder with excel data

I have an Excel file with some 2000 records and a folder with some 4000
pictures, the file name of the picture is the same as the id name in the
excel spreadsheet. Over time the some of the pictures have become
redundant, how do I automatically delete the redundant pictures based on the
excel spreadsheet. Or is it a manual exercise

tia
--
neil
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 213
Default Managing a picture folder with excel data

I have an Excel file with some 2000 records and a folder with some
4000 pictures, the file name of the picture is the same as the id name
in the excel spreadsheet. Over time the some of the pictures have
become redundant, how do I automatically delete the redundant pictures
based on the excel spreadsheet.


Here's one way.

First use the DIR command-line operation to get a folder listing into a
text file. You can start with http://support.microsoft.com/kb/196158.

In a new sheet of the workbook, paste the entire text file into column A.

In column B of the new sheet, use IF and MID and concatenation to
(a) identify which lines are files and
(b) get the file names into column B.

On the new sheet, use VLOOKUP to identify which files have (or don't have)
a corresponding record.

On the original sheet, use VLOOKUP to identify which records have (or don't
have) a corresponding file.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract MS Excel Data embedded in MS Word qualityprocess Excel Discussion (Misc queries) 0 April 20th 06 05:52 PM
data entry in excel by linking to other word doc. or excel sheets wangxuqin Excel Worksheet Functions 1 April 14th 06 12:33 PM
Retrieve data from separate Excel session JessK Charts and Charting in Excel 2 March 27th 06 01:34 AM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 08:05 PM
Linking the data from one excel to another mrbalaje Excel Discussion (Misc queries) 2 June 13th 05 10:44 AM


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"