Search:

Type: Posts; User: GarySut

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

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

    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....
  2. 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...
  3. Re: How can I detect and change the system audio level in Excel?

    I guess I am just not cut out for this one. It looks as if I have to read through and understand 300 lines of code just to read/set the volume control through for this idea.

    IGU......
  4. Re: How can I detect and change the system audio level in Excel?

    I have done significant research to find the variable to read the present volume level from the mixer but have not found it. From there, I should be able to increment/decrement/ reset it as needed....
  5. Re: How can I detect and change the system audio level in Excel?

    OK, I have it working. By double clicking on a cell in excel, I can increase, decrease and even mute the volume.
    I still need to know what the volume presently is.
    How do I capture that value,...
  6. Re: How can I detect and change the system audio level in Excel?

    Silly me, I thought it was a variable already defined for the mixer...
    I will get into it later this evening.
  7. Re: How can I detect and change the system audio level in Excel?

    hmixer is not defined.
  8. How can I detect and change the system audio level in Excel?

    In my Excel project, I want to create and Automatic Gain Control (AGC) to help maintain a more concictent volume. It should be slow enough to allow for natural changes.

    I am using...
  9. Re: How do I Differentiate between instances of Internet explorer using VBA in Excel.

    I appreciate your response but this has proven to be more complicateder than I can handle at the moment. As a result, I have solved the problem in a different way. To explain what I did would...
  10. Re: How do I Differentiate between instances of Internet explorer using VBA in Excel.

    I am going to have to do more testing but it does look as if all IE windows are shut down and not only the ones that are created by my program. At the moment, this is not a serious problem in that I...
  11. How do I Differentiate between instances of Internet explorer using VBA in Excel.

    If I have two or more instances of Internet Explorer open, what VBA code can I use in Excel to be able to close a specific one?
    ie.quit closes all of them even ones that have nothing to do with the...
  12. Re: I want to trigger a sub routine every minute.

    Ok, I thought Excel Developer was VB.net so I guess I stand corrected.
    Mea Culpa.
  13. Re: I want to trigger a sub routine every minute.

    Actually, I just finished the code a few seconds ago and I did use Application.OnTime.
    It was a lot easier than I thought. It turns out to be:

    Application.OnTime Now +...
  14. I want to trigger a sub routine every minute.

    I have been using "Application.OnTime" to trigger a different sub according to a given hour.
    You can can use the same method or some other code if you like.
    Thanks....
  15. Replies
    0
    Views
    457

    Automatic gain control program, how to?

    Since this requires access to the Microsoft volume control, it is a bit out of my league. Maybe someone here can help me design it.

    I record hourly programs using a Jukebox I designed using Excel...
  16. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    Corectamundo...
    That was it.

    I was thinking the error was elsewhere....
  17. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    Apparently it doesn't, any suggestions?
    I can see why but don't see the fix.

    ' Me.BackColor = BlendColors(System.Drawing.Color.FromArgb(R1, G1, B1), System.Drawing.Color.FromArgb(R2, G2, B2)...
  18. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    Easy, Elegant, nice....

    Add "Dim _CurrentAlha as double" and a button to enable the timer.
    I will see if it works with "System.Drawing.Color.FromArgb(R, G, B)" and twerk back.
  19. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    Hey, don't mock me, I am very good with inaction code....

    Yes, I give Twerking demonstrations on weekends.
    That is what I tell my students.
    They have such tender minds.....
  20. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    I fully understand it is a demo but I would like to see it inaction and then twerk it to my needs.

    I did create the WPF, saw the Form1.AMXL and then clicked on View Code. I used copy/paste to...
  21. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    I know WPF with a T instead of a P, are they similar (:

    I experimented but just got errors.
    Where does the code go.
    Tell me where to put it....
  22. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    I have been using:


    Dim R, G, B As Integer
    For I As Integer = 1 To 15 'one cycle for each peg
    R = 1 + (254 * Rnd())
    G = 1 + (254 * Rnd())
    B = 1...
  23. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    Although your code gets the job done I am smitten with Sitten Spynne's missive.
    (:

    Gotta try it.....
  24. Replies
    23
    Views
    2,243

    Re: Dissolve from green to yellow?

    Thanks for the quick responses. Shaggy Hiker code is nice ad easy. I did not realize that all I had do was to change the red value. Sitten Spynne's code does look intriguing.
  25. Replies
    23
    Views
    2,243

    Dissolve from green to yellow?

    Using the code:
    btnPeg.BackColor = System.Drawing.Color.FromArgb(R, G, B)
    I would like to see the code that will dissolve the backcolor from green to yellow.
  26. Re: Is the re an easy way to pluck out the set of digits from a textbox entry?

    Got it, the addition of "c" fixed it. I was trying to use the "help' screens but...
  27. Re: Is the re an easy way to pluck out the set of digits from a textbox entry?

    The line:

    Dim numbers As String = txtLineOfText.Text.Split("-")(1)

    works but either Option Explicit or Option Strict doesn't like it but I am not all that concerned for the moment.
    ...
  28. Is the re an easy way to pluck out the set of digits from a textbox entry?

    Two sets of data in a line are separated using a "-" as follows: XXXX - ###, or XXXXXX - ##, or even XX - ###
    The number of digits at the end can change from 1 to 4. The hyphen is a separator.
    ...
  29. Re: Occasional report of errors but cannor recover from the report.

    Wow, thank you for the extremely informative explanation in a format that I understand. I will be sifting through it in the next day or so. Can I attach a zip file of the project here? Maybe I can...
  30. Re: Occasional report of errors but cannor recover from the report.

    I guess the only thing I can do is watch for the patterns that cause it. Then I can say "When we do this then that happens." rather than just saying "That happens". Then I am sure that you can help...
  31. Re: Occasional report of errors but cannor recover from the report.

    Interesting thought. I have not mentioned that that can be done but I will ask the student. It is doubtful, they are not all that sophisticated.

    You seem to suggest that it is hazardous. If so...
  32. Re: Occasional report of errors but cannor recover from the report.

    Let's start with the fact that I understand little of what you are saying. It is like I am in water and occasionally can float up to take a breath of air.

    Also, I saw little of this problem in...
  33. Occasional report of errors but cannor recover from the report.

    If I knew the proper terminology I guess I would spell this out clearly but I will try.

    First of all, let me say that I teach a VB course in VS2017 to students who are not computer science majors....
  34. Re: HOw do I create a variable that will be visible over several forms?

    Aren't you someone I metaphor?
    Mataphors be with you.

    What is a metaphor?
    Sheep to graze in.
  35. Re: HOw do I create a variable that will be visible over several forms?

    I wonder what you are thinking but I achieved it declaring variables in a module as suggested here.
    It was so easy that my first year VB class understood and are using it in their projects.This is a...
  36. Re: VB in VS2017 Blue Screen of Errors problem/question

    I missed it by "that much..."
    I will see if I can get a new shot.

    As for zip files, that is exactly what I am doing and I take it one step further. The working file has a version number that...
  37. Re: VB in VS2017 Blue Screen of Errors problem/question

    I would consider that but these students are not all that sophisticated. Besides, this is an in-class lecture and the entire project was created that day. Also, I was helping the student with a...
  38. Re: VB in VS2017 Blue Screen of Errors problem/question

    It seems to be random and rare.

    Relates or not: I have also seen two situations now, separate computers/students where in creating a button, it is flagged as an improper property value or...
  39. Re: VB in VS2017 Blue Screen of Errors problem/question

    What is said here is all well and good, and i actually understand most of it. However, this is a beginner's class and all they have used so far is a few buttons, a few labels, colors from the...
  40. Re: I would liike to streamline calculation of grades exorted into Excel.

    I regret the delay is following through on this but be assured that I am still very much interested in getting this working. I used copy/paste to insert the code into a module. I then created the...
Results 1 to 40 of 74
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width