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

Go to webpages of companies that make CD changes and look at the
documentation. If you need help implimenting manufaturers features then
post the details at this site.

"BillyRogers" wrote:

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