can I use VBA to change the format of audio recorded using Peter 12/25/2008 11:13:00 AM Briefly: I can record audio in word but I would like to use VBA to compress this to a more managable file size e.g. 10 secs in the default format is 1.8MB and in the compressed format it is 30kB How can I do this compression under vba control? More info: By default the audio is recorded as PCM 44kHz 16 bit stero WAV which huge 10 secs = 1.5 MB I can use compress this in Word by right clicking the audio icon > Sound recorder document object > Edit > file > properties > playback format > convert now > select MPEG layer 3 > 16 kBpsec 8kHz mono > Ok . and then I end up with a 21 k file that is fine for the audio comment. VBA to record the sound is: Sub recordSound() Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _ LinkToFile:=False, DisplayAsIcon:=False End Sub thanks in advance for any assistance Peter Evans

Re: can I use VBA to change the format of audio recorded using "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/27/2008 10:09:04 AM You are not recording sound in Word, but in Sound Recorder, which doesn't appear to have any extensions that can be programmed from Word vba. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Peter wrote: [Quoted Text] > Briefly: > I can record audio in word but I would like to use VBA to compress > this to a more managable file size e.g. 10 secs in the default format > is 1.8MB and in the compressed format it is 30kB > How can I do this compression under vba control? > > More info: > By default the audio is recorded as PCM 44kHz 16 bit stero WAV which > huge 10 secs = 1.5 MB > > I can use compress this in Word by right clicking the audio icon > > Sound recorder document object > Edit > file > properties > playback > format > convert now > select MPEG layer 3 > 16 kBpsec 8kHz mono > Ok > . and then I end up with a 21 k file that is fine for the audio > comment. > > VBA to record the sound is: > > Sub recordSound() > Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", > FileName:="", _ LinkToFile:=False, DisplayAsIcon:=False > End Sub > > thanks in advance for any assistance > Peter Evans

RE: can I use VBA to change the format of audio recorded using alborg 12/30/2008 6:02:00 AM I agree with Graham- Word doesn't add too many controls. What I would suggest, though, is for you to use Audacity, a highly rated FREE program for recording. You then can add your sound, s.a. MP3 into your Word document. This nifty recorder rocks.... URL: http://www.guidesandtutorials.com/audacity-tutorial.html Al "Peter" wrote: [Quoted Text] > Briefly: > I can record audio in word but I would like to use VBA to compress this to a > more managable file size e.g. 10 secs in the default format is 1.8MB and in > the compressed format it is 30kB > How can I do this compression under vba control? > > More info: > By default the audio is recorded as PCM 44kHz 16 bit stero WAV which huge 10 > secs = 1.5 MB > > I can use compress this in Word by right clicking the audio icon > Sound > recorder document object > Edit > file > properties > playback format > > convert now > select MPEG layer 3 > 16 kBpsec 8kHz mono > Ok . and then I end > up with a 21 k file that is fine for the audio comment. > > VBA to record the sound is: > > Sub recordSound() > Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _ > LinkToFile:=False, DisplayAsIcon:=False > End Sub > > thanks in advance for any assistance > Peter Evans > > > > >

RE: can I use VBA to change the format of audio recorded using alborg 12/30/2008 7:13:01 AM Oh- also check out the MS Office Proofing Tools 2003 here: http://www.microsoft.com/products/info/product.aspx?view=22&pcid=071b9ced-ed82-47ef-b5fa-a42ecbdec9b7&type=ovr Cheers, Al "alborg" wrote: [Quoted Text] > I agree with Graham- Word doesn't add too many controls. What I would > suggest, though, is for you to use Audacity, a highly rated FREE program for > recording. You then can add your sound, s.a. MP3 into your Word document. > This nifty recorder rocks.... > > URL: http://www.guidesandtutorials.com/audacity-tutorial.html > > Al > > "Peter" wrote: > > > Briefly: > > I can record audio in word but I would like to use VBA to compress this to a > > more managable file size e.g. 10 secs in the default format is 1.8MB and in > > the compressed format it is 30kB > > How can I do this compression under vba control? > > > > More info: > > By default the audio is recorded as PCM 44kHz 16 bit stero WAV which huge 10 > > secs = 1.5 MB > > > > I can use compress this in Word by right clicking the audio icon > Sound > > recorder document object > Edit > file > properties > playback format > > > convert now > select MPEG layer 3 > 16 kBpsec 8kHz mono > Ok . and then I end > > up with a 21 k file that is fine for the audio comment. > > > > VBA to record the sound is: > > > > Sub recordSound() > > Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _ > > LinkToFile:=False, DisplayAsIcon:=False > > End Sub > > > > thanks in advance for any assistance > > Peter Evans > > > > > > > > > >

RE: can I use VBA to change the format of audio recorded using alborg 12/30/2008 7:23:00 AM Oops- the 2nd message was meant for another thread. (sorry) Al "alborg" wrote: [Quoted Text] > Oh- also check out the MS Office Proofing Tools 2003 here: > > http://www.microsoft.com/products/info/product.aspx?view=22&pcid=071b9ced-ed82-47ef-b5fa-a42ecbdec9b7&type=ovr > > Cheers, > Al > > "alborg" wrote: > > > I agree with Graham- Word doesn't add too many controls. What I would > > suggest, though, is for you to use Audacity, a highly rated FREE program for > > recording. You then can add your sound, s.a. MP3 into your Word document. > > This nifty recorder rocks.... > > > > URL: http://www.guidesandtutorials.com/audacity-tutorial.html > > > > Al > > > > "Peter" wrote: > > > > > Briefly: > > > I can record audio in word but I would like to use VBA to compress this to a > > > more managable file size e.g. 10 secs in the default format is 1.8MB and in > > > the compressed format it is 30kB > > > How can I do this compression under vba control? > > > > > > More info: > > > By default the audio is recorded as PCM 44kHz 16 bit stero WAV which huge 10 > > > secs = 1.5 MB > > > > > > I can use compress this in Word by right clicking the audio icon > Sound > > > recorder document object > Edit > file > properties > playback format > > > > convert now > select MPEG layer 3 > 16 kBpsec 8kHz mono > Ok . and then I end > > > up with a 21 k file that is fine for the audio comment. > > > > > > VBA to record the sound is: > > > > > > Sub recordSound() > > > Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _ > > > LinkToFile:=False, DisplayAsIcon:=False > > > End Sub > > > > > > thanks in advance for any assistance > > > Peter Evans > > > > > > > > > > > > > > >