Search:

Type: Posts; User: Dan_W

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. Replies
    10
    Views
    1,336

    Re: Excel VBA Clipboard error

    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...
  2. Replies
    8
    Views
    1,045

    Re: ConvertFromulaToVBA

    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...
  3. Re: Use VBA to create a Visual Basic 64 bit Add-in for Excel

    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.
  4. Re: Creating a Visual Basic 64 bit Add-in for Excel

    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...
  5. Re: Creating a Visual Basic 64 bit Add-in for Excel

    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...
  6. Replies
    2
    Views
    372

    Re: Progresscolor keeps in default...

    Presumably, there are values assigned to m_hWndPB and PBM_SETBARCOLOR?
  7. Re: conver Visual C++ 6.0 improve Brightness code to vb6

    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)


    ...
  8. Replies
    9
    Views
    961

    Re: Sanity Check - Using Excel for Database

    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...
  9. Re: Visual Basic to update the caption on an ActiveX label on an Excel worksheet

    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...
  10. Replies
    3
    Views
    671

    Re: Linking vb6 with whatsapp

    This might help: https://leandroascierto.com/blog/enviar-documentos-por-whatsapp-con-vb6/
  11. Replies
    7
    Views
    1,236

    Re: I don't understand where the error is.

    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...
  12. Replies
    13
    Views
    1,960

    Re: Converting A Doc (Or Docx) file to an RTF File

    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?
  13. Thread: Gradient colour

    by Dan_W
    Replies
    4
    Views
    641

    Re: Gradient colour

    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...
  14. Replies
    6
    Views
    2,597

    Re: [VB6] How to use GPU from VB6 using opencl

    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...
  15. Replies
    6
    Views
    2,597

    Re: [VB6] How to use GPU from VB6 using opencl

    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...
  16. Replies
    17
    Views
    1,757

    Re: Word Automation again

    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...
  17. Thread: APV File Format

    by Dan_W
    Replies
    1
    Views
    5,467

    Re: APV File Format

    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:...
  18. Thread: MouseMove

    by Dan_W
    Replies
    15
    Views
    1,051

    Re: MouseMove

    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...
  19. Replies
    2
    Views
    823

    Re: C64 Basic Banchmarking Video

    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...
  20. Re: VB6 Question: drag handle bottom right corner

    There is a pseudo resize corner made in VBA for UserForms that uses the Marlett font. https://andypope.info/vba/resizeform.htm

    188521
  21. Re: Creating a CustomTaskPane - VB6 addin for Office

    I've not actually had an opportunity to try it out, but is this not what you're after?...
  22. Re: vb6 unicode control by Microsoft Forms 2.0 Object Library

    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...
  23. Re: [RESOLVED] Fastest way to clear cells based on cel length

    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
    ...
  24. Replies
    4
    Views
    1,428

    Re: Accessing Interfaces in VBA

    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...
  25. Replies
    4
    Views
    1,428

    Re: Accessing Interfaces in VBA

    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...
  26. Replies
    4
    Views
    869

    Re: Excel internal link

    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.
  27. Replies
    4
    Views
    881

    Re: [RESOLVED] Exporting an array formula

    Alternatively, you could use:


    TargetWS.UsedRange.Formula = SourceWS.UsedRange.Formula

    By way of (unnecessarily long) example:


    Sub TransferFormulas()
  28. Thread: Goto Line

    by Dan_W
    Replies
    9
    Views
    1,157

    Re: Goto Line

    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.
  29. Thread: Goto Line

    by Dan_W
    Replies
    9
    Views
    1,157

    Re: Goto Line

    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...
  30. Re: get element from dropdown in web page

    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...
  31. Re: get element from dropdown in web page

    Are you referring to the drop-down box listing European state members that use VAT?
  32. Replies
    38
    Views
    3,124

    Re: ChatGPT is truly revolutionary.

    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...
  33. Re: VB6 - WinAPI: there is a function for enable the Double Buffering?

    I found this article (and related code sample) really helpful in understanding buffering. It uses the CreateCompatibleDC and CreateCompatibleBitmap that vb6forever helpfully references above -...
  34. Replies
    14
    Views
    1,958

    Re: get process exe is x64 or x86

    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
  35. Re: Arrays: can i initialization a multidimention arrays with '{'?

    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 =...
  36. Replies
    14
    Views
    1,958

    Re: get process exe is x64 or x86

    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...
  37. Re: capturing the text data of a webpage as it appears

    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...
  38. Re: Getting the ball rolling. Which VB6 projects are you working on?

    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...
  39. Re: Comparison of Drawing Efficiency GDI, GDI Plus, Direct2D

    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...
  40. Re: Comparison of Drawing Efficiency GDI, GDI Plus, Direct2D

    Forgive me if this is a silly question, but where would OpenGL rank in this list? Or is it not even in the running?
Results 1 to 40 of 95
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width