copy and paste from "my documents" to excel

  rsfackrell 13:30 24 May 03

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() & "\" & "*.*")


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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch