copy and paste from "my documents" to excel

  rsfackrell 13:30 24 May 03
Locked

i currently have 7000 mp3 files stored in my docs/my music etc. to make it easier to find out whether or not i have a song, i thought it would be a good idea to compile a database in microsoft excel but, i don't fancy having to retype all the .mp3 file names into excel. is there a way of using the copy and paste function to transfer said data to excel or do i need to start typing?? thanks muchly!

  VoG™ 13:34 24 May 03

Have a look at this click here

change this line

MyFile = Dir(CurDir() & "\" & "*.*")

to

MyFile = Dir(CurDir() & "\" & "*.mp3")

  rsfackrell 13:59 24 May 03

sorry to those people who were good enough to post a response to my question, especially VoG who replied within minutes, however, i meant to say can paste & copy from my docs/my music to microsoft access? Had a large beer session last night and it's affecting my ability to think and type!

  VoG™ 14:43 24 May 03

click here might help you.

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…