Results 1 to 4 of 4

Thread: use excel for event log

  1. #1

    use excel for event log



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a problem with a neighbour with a noisy dog and I need to create a log which is triggered by an audio input.

    I am wondering if windows and excel can be programmed to initate actions based upon an audio trigger.

    If possible I also want to record the audio to a portable hard drive.

    Obviously the activity would not be continuous and only occur when there was a sufficiently loud noise.


    I would appreciate any suggestions



  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Neat concept, but I'm thinking that the development time in this would be lengthy... you'd need to discover an API for sound, and be able to tap into it's volume levels to trigger data recording. Most code samples I see from a quick search are around clicking a button to turn recording on, not monitoring the mic for certain audio levels.

    I'm sure that it probably could be done, but honestly, it's going to take a LOT of work to make it happen. Depending on the hardware you have it may also cost as well...
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Ken,

    thanks! for the comment. It can be done. see this web page:

    http://www.ispyconnect.com/features.aspx

    but it doesnt have the code

    Shesez

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Right, but if you dig through there, you'll find that you can download the code. The issue, though, is this:

    iSpy is written in c#. The project is a Visual Studio 10 solution (you will need Visual Studio 2010 to compile it).
    So the issue we have here is that the VBA Editor works with VBA, which is a flavour of Visual Basic. Unless they released a dll that can be referenced (and probably some code samples), most Excel programmers won't be able to help.

    I believe that, given enough time and the right person, that this can certainly be accomplished. I'm just not sure who that person is. I'll make a call and see if I can get someone to look at this.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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