Embedding and accessing a file in Excel with VBA and OLE Objects
Danial Chowdhury

Wonderfull article although it does not work for me :-(

I copied all the code to excel to make a workbook that sends out order emails when a stock gets below a threshold. It should take the orderform from an embedded word.doc but I get an runtime error 424 Object required.

In your last sub where the

‘ Now we have EmbeddedFileName, you can play this with something like Call sndPlaySound32(EmbeddedFileName, 0)


Any ideas?

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.