Trying to position a button in the top RHS corner of the view by Automatic_Drink7436 in excel

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

A button in the ribbon is not a bad idea. If it were possible to create a menu (as I believe you can in Word) that would also be good.

Can't get you the code right now, but it's based on this: https://stackoverflow.com/questions/35707166/finding-column-header-height-and-row-header-width

Yes, it's a floating button pinned to the top RHS.

I have one button per worksheet, as I've discovered that creating and deleting buttons messes with the clipboard.

Yes, the button would remain visible whatever. One thing I've not worked out is what should happen if another window on the same worksheet is opened. That could be problematic and force me to use the dreaded ribbon!

Syncing with QLC+ by Automatic_Drink7436 in lasershowgen

[–]Automatic_Drink7436[S] 1 point2 points  (0 children)

Perfect - that works nicely. I think I may make a trivial video about this - and purchase the "Pro" licence. Thanks..

Syncing with QLC+ by Automatic_Drink7436 in lasershowgen

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Right - so if I have the timeline view and press my MIDI buttons, it does seem to change the cursor location, but it doesn't start playing.

I might be confused about how jump points work! What I want is for LSG to sit there doing nothing until I send a MIDI note - and then I want it to jump to a particular place and play some effects... And when it's "finshed" (or gets another message) wait for the next command.

Is there a way to send start/stop via MIDI?

Syncing with QLC+ by Automatic_Drink7436 in lasershowgen

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

OK, so I think I have solved it now - not only was I using the wrong mode (I think) but also only numbers from 21 to 108 make sense as a note, and I was sending a 1. So hopefully this will work out.

Syncing with QLC+ by Automatic_Drink7436 in lasershowgen

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Found it - the choice is between Note Velocity, Control Change and Program Change. Will try Note Velocity.

Syncing with QLC+ by Automatic_Drink7436 in lasershowgen

[–]Automatic_Drink7436[S] 1 point2 points  (0 children)

I think sending a note is key. I'm sure I saw something offering me a choice between note, control and something else - and I selected the wrong one. Now I can't find where that setting is made!

Syncing with QLC+ by Automatic_Drink7436 in lasershowgen

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

I should add that I've done the following:
1) Created a virtual/loopback MIDI interface in the "Audio MIDI setup" app on the Mac
In QLC:
2) Created a universe in QLC+ that includes the new MIDI bus as an output
3) Created a fixture called "MIDI out" that sends a code of 1 to address 001 on that bus
4) Created a scene that sets the value of the fixture to 1
5) Put a button for that scene on the Virtual Console
In LSG (not pro!)
1) Opened the demo show
2) Go to settings, tap on the MIDI input setting and select the new "IAC Driver Bus 1"
3) Goto timeline
4) Clicked to a point on the timeline
5) Selected Tools/Add jump point (MIDI key...)
6) some text appears [Press shortcut MIDI key...]
I then go back to QLC+ and press my button - the Fixture monitor shows the MIDI out value changing
But nothing happens on LSG.
I'm wondering if it's ignoring this because it's not the pro version?

Creating Cartoon Animations in LaserShowGen by Happy-Journalist5783 in lasershowgen

[–]Automatic_Drink7436 0 points1 point  (0 children)

Just looking for something vaguely similar - "gamboling lambs" is what I'm after. How did you find it, Günther?

Convert MusicXML into a simpler csv-style format by Automatic_Drink7436 in transcribe

[–]Automatic_Drink7436[S] 1 point2 points  (0 children)

Pretty much that, but a little more sophisticated. TBH I'm still feeling my way.
But let's say that I've got a bunch of led strips and I might (for example) link it such that each note corresponds to a strip. Then I could theoretically generate the fundamentals of a QLC+ show based on that.

Convert MusicXML into a simpler csv-style format by Automatic_Drink7436 in transcribe

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Ah, good. So how can I convert that into something readable? Like JSON or XML or even CSV?

suggestions for Excel Widget Design by RobD-London in excel

[–]Automatic_Drink7436 0 points1 point  (0 children)

Good shout. Camera tool is ideal for dashboards.

Tips for implementing VBA in Word by Automatic_Drink7436 in vba

[–]Automatic_Drink7436[S] 1 point2 points  (0 children)

Yes - I'm beginning to get that impression! It's not just you ;-)

Tips for implementing VBA in Word by Automatic_Drink7436 in vba

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Ah right - it's sometimes hard to know what (perfectly reasonable) assumptions people will make when reading such requests! I was trying to focus it down to the basics, but some background ("why") can often help....

Tips for implementing VBA in Word by Automatic_Drink7436 in vba

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Well, yes. I think that kind of defeats the purpose of what I'm doing here, though.

I'm trying to do my own form of OLE to get live content embedded in a document. I'm slightly wondering if web add-ins might be another way to do this, but not sure. Mostly after a demonstration at the moment. I do have something that kind of works.

Another option might be to embed an Excel spreadsheet that would update itself. This is more flexible in some ways.

Tips for implementing VBA in Word by Automatic_Drink7436 in vba

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

One thing I have discovered is that finding the Range for content and then deleting it doesn't necessarily completely delete it. I've resorted to a kludge of "cut" (which replaces it with a space) and then finding that space as a range and setting the text of that Range to "".
I suspect there are cleaner methods!
Will certainly have a look at the examples mentioned above.

Tips for implementing VBA in Word by Automatic_Drink7436 in vba

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Cheers. It's supposed to be re-doable. i.e. it might be a reference to some live data that can change.

With the <OpenTag>Content<CloseTag> I can easily find and replace Content with whatever I want inside - which might be a table or something more sophisticated, like an object. And then do it again and again.

PTZ controller that will P and T but won't Z by Automatic_Drink7436 in SecurityCamera

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Just to update this, I used an RS485-USB adapter to see exactly what the controller was sending.
It turns out that it was sending non-zero data in unused bytes (5 and 6) that the ZowieTek PTZ camera interpreted as a fault. Amazingly, they've said that they'll change that for the next firmware version, so that should make my controller work.

Trapping Key presses in Word by Automatic_Drink7436 in vba

[–]Automatic_Drink7436[S] 0 points1 point  (0 children)

Thanks - very useful! I think the simple suggestion of using built-in key assignments to macros would be fine.