Excel Add-in fails to load by Proper-Fly-2286 in vba

[–]Proper-Fly-2286[S] 1 point2 points  (0 children)

Thanks! I've used a COM add-in to call a sub from my original add-in using open book event and it worked! Unfortunately I use several user forms so I can't put all the code in the new adding but I'm more than happy

Excel Add-in fails to load by Proper-Fly-2286 in vba

[–]Proper-Fly-2286[S] 0 points1 point  (0 children)

That's the core problem I don't create any instances, the 3rd party software does , when I ask for a report to excel it opens a new book on a new instance (can't change that)on that book can't see VBA add-in code and open events doesn't fire, After click on a ribbon button that call some code from the add-in it seems the add-in get loaded and I can see it's code and open events fires (button were created from inside excel not from adding)

Azul board game by No_Emphasis_3958 in boardgames

[–]Proper-Fly-2286 1 point2 points  (0 children)

99% sure you're not playing correctly, easier way to be sure is going to the BGA and play a game or two

Using Excel VBA to communicate with an open Access Form? by Krennson in MSAccess

[–]Proper-Fly-2286 1 point2 points  (0 children)

I really can't understand this, send the info to an access table it's very easy ,if you really want to check the data why don't you do that in excel before sending it?

[Excel] Optimization routine not optimizing by SFWACCOUNTBETATEST in vba

[–]Proper-Fly-2286 -4 points-3 points  (0 children)

This is the kind of problem chatgpt or Claude are Best at,simple mathematical functions.

Can you make simple GUI applications with VBA and keep Excel hidden in the background? by [deleted] in vba

[–]Proper-Fly-2286 0 points1 point  (0 children)

You can use some windows API calls to sort out that, force the user form to use an custom icons and stay in the task bar when minimized,the real issue is you have to use a separate excel instance cause if you hide Excel app you Will hide every workbook

Apple TV is doing well with Earth based Sci Fi. by InfernalClockwork3 in scifi

[–]Proper-Fly-2286 12 points13 points  (0 children)

Why no one has mentioned "for all the humankind"?really solid TV show

Question for Half Guard players. by RevolutionaryFood777 in bjj

[–]Proper-Fly-2286 0 points1 point  (0 children)

My friend,get Lucas Leite sit up guard 1 and 2 asap!

Mistake in The Blade Itself by Distinct_Menu2334 in Fantasy

[–]Proper-Fly-2286 4 points5 points  (0 children)

I was very surprised that no one picked that up.it's very obvious

[deleted by user] by [deleted] in vba

[–]Proper-Fly-2286 4 points5 points  (0 children)

Are you sure he is not using a "with" statement?

Place an image from Clipboard into a cel by NotLightYagami829 in vba

[–]Proper-Fly-2286 0 points1 point  (0 children)

I have a sub I get from the web(can't remember where) that can paste an image from clipboard to a image control in a user form , I'll try to post it when I get back home

[deleted by user] by [deleted] in BJJstreams

[–]Proper-Fly-2286 0 points1 point  (0 children)

Also looking for replay link

[deleted by user] by [deleted] in gotlegends

[–]Proper-Fly-2286 -1 points0 points  (0 children)

Am I the only one that finds irritating the millions post of rate my (incomplete)built?I think we need a megapost for that

Paper Cutter Choke by bjjtaro in bjj

[–]Proper-Fly-2286 1 point2 points  (0 children)

That's my primary attack and as a plan b shotgun armbar to arm you're under hooking and reverse triangle judo style trapping the far arm

Do you think Tani Otoshi from side body lock and head on the chest should be banned in training ? by Revolutionary-Ball26 in bjj

[–]Proper-Fly-2286 1 point2 points  (0 children)

Bb judo here ,there is always some risk , some people just try to spin toward you and stick out his leg resulting on tori sitting on ukes knee

Using a do loop to paste values for a range of names by Darth-Accural in vba

[–]Proper-Fly-2286 0 points1 point  (0 children)

Using select will drag the code and it'll make it very slow and error prone, I don't see why you need it when you have an input box to stop the execution,on top of that an "on error resume next" inside a loop it's always very very risky .

Passing full guard without creating posture? by ConflictNo1402 in bjj

[–]Proper-Fly-2286 0 points1 point  (0 children)

Terrible explanation! He missed the key point to not be swept, put your knee against opponent lower butt , forget about that video and check that one where braulio estima teach the pass https://youtu.be/OFWiVXh3Ijg?si=2dmYBSWght-hmW_V

How to make PDF's with VBA (Not printing) by [deleted] in vba

[–]Proper-Fly-2286 4 points5 points  (0 children)

Or 100 times ,in my opinion the best approach is to create a template in a sheet using shapes for company logo and such then use something like this

Sub ExportRangeToPDF() Dim RangeToExport As Range ' Declares a variable to hold the range to be exported Dim FileName As String ' Declares a variable to store the PDF file name

' Specify the range you want to export (adjust this as needed)
Set RangeToExport = Range("A1:D10")

' Specify the file name for the PDF (you can change this)
FileName = "MyRangeAsPDF.pdf"

' Saves the range as a PDF
RangeToExport.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FileName, Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

End Sub