Results 1 to 4 of 4

Thread: Can I code an Automatic Volume Control is Excel/VBA code?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2017
    Posts
    72

    Can I code an Automatic Volume Control is Excel/VBA code?

    What might the VBA code be, when using Excel developer/Visual BASIC in a spreadsheet, to detect the recording volume and increase/decrease the volume as needed automatically?

    I have a hundreds of lines of VBA code in my spreadsheet. It calls various URLS to play audio clips and they are called and recorded hourly. It seems that web sites do not use the Dolby Calibration standard to set their volumes. Some are very low while some overload my speakers.

    Somehow I would like to build an automatic volume control to be active when I am recording.

    Here is the image of a 20 hour recording. Two one-hour clips are overloaded.

    Name:  Audacity AGC needed.jpg
Views: 812
Size:  8.3 KB

  2. #2
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Can I code an Automatic Volume Control is Excel/VBA code?

    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Apr 2017
    Posts
    72

    Re: Can I code an Automatic Volume Control is Excel/VBA code?

    Quote Originally Posted by westconn1 View Post
    Wow, 17 years ago. I guess I had too much on my plate at that time to make use of the code. Time to try it again...
    Thanks....

  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Can I code an Automatic Volume Control is Excel/VBA code?

    well it was a while ago, but i think 17 years was a miscalculation more like 3
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width