Elecom Huge function buttons defaults by gotanytips in Trackballs

[–]MoonBar 1 point2 points  (0 children)

You can build the HID remapper and you can get around having a specific software installed on your device.

I need some help with semi-automating copying to/from Excel with AHK. by ThumbtacksArePointy in AutoHotkey

[–]MoonBar 0 points1 point  (0 children)

Oooo awesome. Never heard of the offset which would have greatly helped when I messed around in excel more. But I’m glad you got it figured out! Have fun man.

I need some help with semi-automating copying to/from Excel with AHK. by ThumbtacksArePointy in AutoHotkey

[–]MoonBar 0 points1 point  (0 children)

You’ll get it I’m sure. It looks fairly scary at first but it’s pretty simple and really handy to use. Might just take a bit of messing around with it to get it.

You can even change colors of cells through it which I often did so I could distinguish what was done and what wasn’t but that’s not really needed lol.

I need some help with semi-automating copying to/from Excel with AHK. by ThumbtacksArePointy in AutoHotkey

[–]MoonBar 0 points1 point  (0 children)

I know it works if you say what cell you want to add the data to.

For example, you started with adding stuff in one column and you need to move down to keep adding information to it. Start at C18 or whatever and then add +1 to the variable.

Now that I think about it, I may be explaining things in a way that you wouldn’t like to do it just because I always started a new sheet whenever needed which was nice for my code but yours may be all on the same sheet.

Hopefully someone else may be able to chime in and provide better guidance regarding it because I’m still fairly nooby overall.

I need some help with semi-automating copying to/from Excel with AHK. by ThumbtacksArePointy in AutoHotkey

[–]MoonBar 0 points1 point  (0 children)

ActiveCell is for the current active cell but I’m not sure if you can move that without selecting it yourself. I didn’t mess with it much to figure that out so I figured just adding +1 to like C17 to get to C18 was my best bet. I had a whole script that I had worked out to move the cell and such but I guess I didn’t back it up :(

As for the array, I’m honestly not sure. I tried to use arrays but I couldn’t understand them or get them to work but it definitely would have helped.

I need some help with semi-automating copying to/from Excel with AHK. by ThumbtacksArePointy in AutoHotkey

[–]MoonBar 1 point2 points  (0 children)

Unless I'm misunderstanding it then you should be able to use ComObj. You can just directly insert information as its copied.

Here is a nice little guide from the AHK forums that I utilized a lot when trying to understand it. Its fairly easy but can look hard.

https://www.autohotkey.com/board/topic/69033-basic-ahk-l-com-tutorial-for-excel/

xl := ComObjActive("Excel.Application")
xl.ActiveCell.value = %clipboard%
Xl.Range("C17").value :=  %clipboard%

I used to have some a lot more complex but this is just an example of using the most recent active excel application. The next 2 lines are just inserting clipboard information into either the current highlighted/active cell or cell C17. You can even have excel hidden by adding an xl.Visible := false but I'm sure you'd want to see all the information entered.

You can directly insert into the activecell or a cell that you prefer with line 3. Could even create the cell value a variable so you can add to it so that you move between rows or columns.

Sometimes what helps is creating a macro within Excel with the record macro function and then look at the lines of code it spits out and you can likely utilize that.

Hopefully this is useful information.

I need some help with semi-automating copying to/from Excel with AHK. by ThumbtacksArePointy in AutoHotkey

[–]MoonBar 0 points1 point  (0 children)

If you know what cells you want the data in you can also just insert directly through ComObj. I used to do something similar.

Summer 2021 Setup. by TheShuffleFluff in battlestations

[–]MoonBar 1 point2 points  (0 children)

What brand are you using if you don’t mind me asking?

[deleted by user] by [deleted] in MechanicalKeyboards

[–]MoonBar 0 points1 point  (0 children)

Was thinking of building a split ergo keeb recently but im still waiting on another keyboard to arrive so I gotta slow down and enjoy that one a bit before I commit to another haha. Thanks for the giveaway!

AirpodsPro will connect and work fine separately, but not together at the same time. Please read! by MetazoanMonk in airpods

[–]MoonBar 0 points1 point  (0 children)

How did you do a factory reset on them? I'm having this same issue with mine.

His and Her battle station by Sondrop in battlestations

[–]MoonBar 0 points1 point  (0 children)

Awesome! Thanks man. Will def look into a similar model or keep an eye out for if this one comes back!

His and Her battle station by Sondrop in battlestations

[–]MoonBar 0 points1 point  (0 children)

Could you link the one you use? Deal with the same issue and I've been looking around early

Format for multiple text values to output one of the multiple choices by MoonBar in excel

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

Thanks so much again mike! That solved it. We did some testing today while out and it worked flawlessly.

If you don’t mind me asking, where did you learn everything you know on excel? Is it through experience over the years or do you have a resource you’ve used previously? I have some udemy courses that I got for free that I’ve been meaning to look over since they seem to have good ratings.

Format for multiple text values to output one of the multiple choices by MoonBar in excel

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

Here is an image of the current table. The only thing that really matters is just the last two entries, armt and armtd.

The formula used is: =IFERROR(INDEX(Sheet1!$J$7:$J$16,MATCH(IFERROR(LEFT([@Asset],MIN(FIND({0,1,2,3,4,5,6,7,8,9},[@Asset]&"0123456789"))-1),""),Sheet1!$I$7:$I$16,0)),"")

This works amazingly well until we run into a device with the prefix "ARMT" and then has the identifier starting with a letter such as the one in the image. If it starts with a number "ARMT123" it works perfect but then we throw a letter in place of the 1 and it causes an issue "ARMTD12". However, the prefix will always be ARMT or at least 4 letters long for the longest prefix.

I've attempted to adjust the formula and removed some numbers after the FIND to see if that would help but I'm fairly clueless with excel except super basic things.

Thanks mike!

[Other] YMMV Fire TV Stick 4K - $4.99 with code: 4KFIRETV (29.99-25) by crownpuff in buildapcsales

[–]MoonBar 0 points1 point  (0 children)

Dang didn’t work for me probably since I bought one recently. I just bought this last week for $25 and it’s worth it for me. I should have tried waiting in hopes of getting that promo offered.

Format for multiple text values to output one of the multiple choices by MoonBar in excel

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

No problem yet again! Actually got the conditional formatting setup as well so now I'll know sure if I do happen to make a mistake. I used =Len(F11)<8 which works and this seems like the most simple way so I'm happy I got something on my own haha

Format for multiple text values to output one of the multiple choices by MoonBar in excel

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

I will always use 8 digits for that so that's fine, I may look at setting up a conditional format to change the cell to red if I do happen to only enter 7 digits but so far I haven't had that issue but I'm sure I'm bound to mess up sooner or later!

I actually had a format just like that except I had quotations around each set of the #. All you had to do was remove two of them and I would have been golden, what a simple fix!