B
BillyRogers
I just finished writing a program that runs a decryption program on some CD's
that we receive each month. It looks up the password for each CD in an
access table and opens and decrypts the cd and saves the contents (.mdb file)
to a folder and then ejects the CD and waits 5 seconds for the user to place
the next CD in the tray before closing and decrypting the next cd. The code
is all in Excel. There are usually 70-80 of these CD's that have to be
decrypted, unlocked and saved each month.
I just had an idea that maybe there is someway to control a CD changer and
completely automate this whole process. Any thoughts on this?
I've never worked with a cd changer before. Do they look just like the D:\
does now for the cd drive? Do they have a windows forms application that
controls the drive?...to where I could use sendKeys to move to the next CD?
Thanks for any advice,
Billy
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003
that we receive each month. It looks up the password for each CD in an
access table and opens and decrypts the cd and saves the contents (.mdb file)
to a folder and then ejects the CD and waits 5 seconds for the user to place
the next CD in the tray before closing and decrypting the next cd. The code
is all in Excel. There are usually 70-80 of these CD's that have to be
decrypted, unlocked and saved each month.
I just had an idea that maybe there is someway to control a CD changer and
completely automate this whole process. Any thoughts on this?
I've never worked with a cd changer before. Do they look just like the D:\
does now for the cd drive? Do they have a windows forms application that
controls the drive?...to where I could use sendKeys to move to the next CD?
Thanks for any advice,
Billy
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003