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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…