Auto-write to CD

[ashg657]

Hi,
Is it possible to automatically , using VBA code, launch the windows xp cd
writing wizard and copy an MDB file to the cdrw directory and burn it?
Any help/links appreciated,
Ash.

 

[Jeff C]

Using VBA and a windows script, you can copy a file (*.MDB) from one location
to another.

Most rewritable CD Drives have software that allows you to place in a CD and
write to it on the fly as you would any hard drive.

Use your script to copy the file to the CD Drive once it is set up that way

 

[ashg657]

Thanks! However, I need to be able to carry out this automated process using
only the built-in WindowsXP CD Writing Wizard.
Ive managed to get as far as getting the wizard to be launch when a backup
is complete, but now, I need to be able to copy the backup file from the C:
drive into the D: drive (CD-RW), keep getting error messages about access
permission and bad file and number.
Im trying to use the FileCopy syntax, works fine for any other media storage
such as flash disks, floppy disk, but not CD, i know its probably because of
read-only but surely someone has a way of achieving this?
Many thanks.

 

[John Nurick]

As far as I know this isn't possible.

One work-round is to shell to a command-line CD writer such as
http://isorecorder.alexfeinman.com/CreateCD.htm . In principle one could
write VBA code to call the API functions used by the Windows CD-writing
wizard (and by CreateCD.exe), but I don't know where the documentation
is.

 

[ashg657]

Yes that seems to be the case. I have done some research on the net, a lot of
people go on about the API functions but no-one seems to know where the
documentation is to be able to program this. Thanks for your help none the
less and I'll leave this one open for further suggestions.
Thanks again.