Copying Multiple Links at One Time

H

heelinva

Need someone's assistance to figure out how one can create multiple
links from files on a hard drive, into a spreadsheet with each file
link located in a separate cell.

Problem: I'm working over in Iraq and support an Iraqi group working
in a forensics area.

The Iraqi team I'm working with wants to produce an Excel spreadsheet
with links to specific files on their hard drive. Trouble is we have
almost 110,000 files to link. Is there a way to do this without
inputing each link individually?

Heelinva
 
J

Jan Karel Pieterse

Hi Heelinva,
The Iraqi team I'm working with wants to produce an Excel spreadsheet
with links to specific files on their hard drive. Trouble is we have
almost 110,000 files to link. Is there a way to do this without
inputing each link individually?
Click to expand...

This sounds like a monster workbook to me, designed for trouble.
I strongly doubt a file with so many links will be stable (if at all
possible).

Also, which such a huge amount of data, maybe Excel simply isn't the
right tool?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
Top