copy a folder contents to a spreadsheet

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

Hello

I want to develop a spreadsheet (Excel) which will have all the files in one
of my folders as on of its columns!

I have tried opening explorer , using copy & paste, but it doesn't seem to
work

Can anybody help please ?

Thanks

KK
 
Hello

I want to develop a spreadsheet (Excel) which will have all the
files in one of my folders as on of its columns!

I have tried opening explorer , using copy & paste, but it doesn't
seem to work

Can anybody help please ?

Thanks

KK
Click to expand...

It really depends on what your main goal is, if you just want to
document a folder contents (a "snap shot" so to say) there are numerous
other and better ways instead of using a spreadsheet.

If you want to make an active spreadsheet that is directly linked to a
folder and updates as new files are added or removed, that is a whole
new ball game, Not impossible but I wouldn't have a clue. I'd think
Microsoft Access would be a better solution for this then Excel.

If you let us know what your objective is we might be able to shed
some more light on it.
 
Why don't you go to an Office Newsgroup?

Dave Cox said:
It really depends on what your main goal is, if you just want to
document a folder contents (a "snap shot" so to say) there are numerous
other and better ways instead of using a spreadsheet.

If you want to make an active spreadsheet that is directly linked to a
folder and updates as new files are added or removed, that is a whole
new ball game, Not impossible but I wouldn't have a clue. I'd think
Microsoft Access would be a better solution for this then Excel.

If you let us know what your objective is we might be able to shed
some more light on it.
Click to expand...
 
Mick,

Thanks for your help.

It seemed to me that the issue lies with explorer, rather than excel, but I
will heed your advice.

Thanks again

KK
 
Back
Top