I want to create a form where the user can insert an object (in this case an
audio file) for later review. I tried to record a simple macro to accomplish
this but I can't stop recording once the navigation windows open.

Hi Mike,

Mike Greene wrote:
I want to create a form where the user can insert an object (in this
case an audio file) for later review. I tried to record a simple
macro to accomplish this but I can't stop recording once the
navigation windows open.

Do you just want a WAV file embedded in the document as an OLE object? If
so, something like this will work:

ActiveSheet.OLEObjects.Add "mysound.wav"

Or are you looking for something more?

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Thanks for the assist, Jake.

I have a spreadsheet/form that is used for reviewing sales cales in the form
of WAV files. I wanted to create a macro that would allow them to select the
file from a directory and insert it into the form for upper management to
review at a later time.

"Jake Marx" wrote:

Hi Mike,

Mike Greene wrote:
I want to create a form where the user can insert an object (in this
case an audio file) for later review. I tried to record a simple
macro to accomplish this but I can't stop recording once the
navigation windows open.

Do you just want a WAV file embedded in the document as an OLE object? If
so, something like this will work:

ActiveSheet.OLEObjects.Add "mysound.wav"

Or are you looking for something more?

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]