Hi,
I want to do the following through excel user form.
1. Check the CD/DVD Rom Drive in the PC
2. If there are more than one CD/DVD Drives it should display the Drive
letters and ask to select any one drive for use.
3. It should eject the cd drive tray and should ask for inserting cd.
4. Should check for a prticular folder and no. of excel files in it.
5. If particular folder is not there it should say "Invalid CD"
6. If CD is valid it should store the serial no. of the cd and should
copy the folder and files to a hard disk folder.
7. After copying files should display a message "Successfully copied.
Enter the Second CD." and should eject the cd tray.
8. It should check the next CD against the serial no., to avoid
duplication.
This should repeat for 10 CDs
**********************
I am receiving data from 10 clients in a CD. I want to copy them and
analyse the data.
Any suggestions comments help sample vba code highly appreciated.
Thank You and Regards
Nelson