Search:
Type: Posts; User: Dan_W
Search:
Search took 0.03 seconds.
-
It's not an error message I've ever seen so I'm not entirely sure, but I tend to find that any issues with the clipboard tend to 'fix' themselves when you force VBA to pause before proceeding with...
-
I tried checking the ZIP file, but Windows says it's an invalid compressed file.
That said, you can easily 'convert' a worksheet formula into VBA by either using the Application.WorksheetFunction...
-
Ahh yes. I take your point - thank you. You're right.
I think I got misled by the MS nomenclature of referring to XLA/XLAM files as Excel Add-Ins.
-
To clarify, what you're trying to do is create some kind of add-in for the VBA IDE?
Yes, you can do it in VBA - by referencing the Visual Basic for Application Extensibility Library v5.3 - it...
-
Yes. Yes. No.
It all depends on what kind of addin you want to make. Excel has its own add-in infrastructure built into via the XLAM file format, which allows you to do all that you can with VBA...
-
Presumably, there are values assigned to m_hWndPB and PBM_SETBARCOLOR?
-
I just tried the code Fafalone provided and had the same result as you. I would point out, though, that the API SetDeviceGammaRamp has a wild number of caveats to it, according to MSDN: (link)
...
-
Very interesting project. As you/others have already pointed out, I'm not sure you even need Excel to do this. I've done something somewhat similar, but I used a combination of Windows Task Schedule...
-
Regardless of the language, the object model for an ActiveX Label control does not, as far as I'm aware, allow you to access the text of an ActiveX Label on a worksheet via the...
-
This might help: https://leandroascierto.com/blog/enviar-documentos-por-whatsapp-con-vb6/
-
I would suggest fully qualifying your range references - this is particularly important when you're getting VBA to work across multiple worksheets. I've adjusted your code below on the first line by...
-
The error message you're getting suggests that your version of Word doesn't have access to the SaveAs2 method. What version of Office are you using?
-
If I understand you correctly, you could use the ColorAdjustLuma API. Adapted from here, the code below demonstrates how it's used and should display something akin to this:
188945
I've used...
-
You're absolutely right - my apologies for missing that one. I've checked it in VBA 64bit and it's working as expected. Thank you both!
On the off-chance anyone needs it, here is the TB/VBA 32bit...
-
Hi. Was discussing with a friend whether it would be possible to access the GPU from VBA, and I recalled this post, but am having a some difficulty porting it to 64bit VBA. I've converted the API...
-
As Phil points out above, it'd be easier to solve the problem if you explained what the problem was.
That said, if (as your code would seem to suggest) you've declared the wrdApp object in the...
-
My project has moved on since I originally posted this, but in case anyone stumbles across this and is interested, they might find the following additional link I found to be useful:...
-
Would this thread help at all? https://www.vbforums.com/showthread.php?888843-Load-image-into-STATIC-control-Win32
If you go through the entire thread, you'll see a number of elements touch on...
-
C64 was my first ever basic, so this is a trip down memory lane. I have PTSD of manually typing in long lists of code from books to try and do pixel graphics in the C64 (POKE? PEEK?), only to never...
-
There is a pseudo resize corner made in VBA for UserForms that uses the Marlett font. https://andypope.info/vba/resizeform.htm
188521
-
I've not actually had an opportunity to try it out, but is this not what you're after?...
-
It's pretty common for VBA UserForm controls. Off the top of my head, the textbox, the image control nor the command button have usable handles, but the frame control does.
Edit: I should clarify...
-
I know this is already resolved, but another option is to convert the entirety of the range into a single string. Using the Names method (see below), this will return a string like:
187992
...
-
Thank you for your reply - I only just saw that anyone even had!
My apologies for the confusion - those were just intended to be examples.
I will take a look at the links more closely later...
-
My apologies, I have literally only just seen this. I didn't think anyone had replied. Thank you so much! A lot to digest, but this looks very helpful. I will take a look at it when I get home...
-
That was my first thought, but I suspect he means the Textbox Shape and not the one you add by way of the Developer tab.
-
Alternatively, you could use:
TargetWS.UsedRange.Formula = SourceWS.UsedRange.Formula
By way of (unnecessarily long) example:
Sub TransferFormulas()
-
Thus the question seeking clarification - what wasn't clear to me is that the code would be opened outside the IDE. Now it is. Thanks.
-
I'm sorry, but I'm not sure I follow. The line of what file? What you've circled in the screen capture shows the line of code if the cursor in the currently active module/form/class, etc - which...
-
I just reread your message... You are referring to what I thought you were.
I suppose the list of European States that use VAT can change, but not often! Countries tend not to rewrite their entire...
-
Are you referring to the drop-down box listing European state members that use VAT?
-
Then I would recommend adjusting the prompt to get the code in VBA, then, because it almost always responds with VB6 code. And with 32 bit API declarations for the most part even when I expressly ask...
-
I found this article (and related code sample) really helpful in understanding buffering. It uses the CreateCompatibleDC and CreateCompatibleBitmap that vb6forever helpfully references above -...
-
You may find the following useful: https://www.mrexcel.com/board/threads/determining-32-bit-versus-64-bit-in-vba-testers-welcome.1123716/post-5424462
-
It isn't really on-point, but you kinda can with VBA. The following is valid syntax and will initialise a 2D array:
Sub TwoDeeArray()
Dim MyArr As Variant
MyArr =...
-
Your 64bit API declarations need fixing - it isn't simply a matter of adding PtrSafe to the declaration, you need to adjust the data types to LongPtr/LongLong where appropriate (e.g., handles like...
-
I'm a bit surprised that even the WebBrowser control is causing you difficulty - one the JS has rendered the page, I would've expected the HTML code to be usable to scrape the contents. As to it not...
-
I love the Face Builder. I had thought about making some kind of Avatar Generator, but nothing nearly as granular or as visually impressive as this. Out of curiosity, are the face...
-
For OpenGL, I've been using the resources available at Developpez.com (link)
The website is in French, but it translates to English with Google Chrome easily enough. You need to create a free...
-
Forgive me if this is a silly question, but where would OpenGL rank in this list? Or is it not even in the running?
|
Click Here to Expand Forum to Full Width
|