Search results

  1. D

    Hidden & little known features in VBA and the VBE

    I'm surprised too, but the assets are still there - the MIDI file is resource 5432 (RCDATA) in the VBE7.DLL and Bitmap Resource 5433 looks to me to be the cloud bitmap image in the background of the animation (on its side): And I'm on MS Office 365.
  2. D

    Hidden & little known features in VBA and the VBE

    I've got plenty of things to say on the topic and more tidbits to share, but a lot tend to focus on the UserForm and the UF controls, and I don't think I fully appreciated that userforms weren't as widely used in Access and I don't want to bore anyone so focussing on the IDE, is anyone aware of...
  3. D

    Hidden & little known features in VBA and the VBE

    Great thread - The VBA IDE and UserForms are probably my two favourite topics. Some of these will be familiar to many, but I'll jot them down just in case. I should add that, for context, I'm coming from an Excel VBA perspective, but I've double-checked the points below to make sure that they...
  4. D

    Solved Read Type Information (Classes & Methods) from COM DLL

    Found it - it was posted on MrExcel on 4 February 2020 and is called "Get list of all Properties and Methods for an object with VBA code alone"
  5. D

    Solved Read Type Information (Classes & Methods) from COM DLL

    That's seems like an odd way of makig a comparison - you're comparing apples with wheelbarrows. Jaafar Tribak's code is usually written with a view to reusability and modularity. So when you contrast it against your barebones snippet - yes, vBA looks 'overly complex' and verbose. So if we strip...
  6. D

    Navigating to webpage with VPN

    I'm not in Portugal either, and it works fine for me. Exactly what problems are you having? Are you getting an error message?
  7. D

    Setting extended property values for external files using VBA

    Hi. I'm very sorry - I didn't see that you had responded - I have been busy moving, and it isn't nearly as much fun as people would have you believe! From what I can see, it isn't Ben's alias, no. Ben uses the clever secret alias bclothier... Fafalone has his name and contact email set out in...
  8. D

    Setting extended property values for external files using VBA

    Happy New Year! Well I have made some progress, and narrowing in on a solution - it'll manner of API chicanery, but my skills in this area have improved. The author of the ucShellBrowser (and of the TaskDialog class) has been active in converting his code over to be TwinBasic compatible. He has...
  9. D

    Solved InputBox with Asterix

    Asterix was indeed a little cartoon character, but it was Obelix who was the fat one with the stripy trousers. :-) #justsaying
  10. D

    Setting extended property values for external files using VBA

    Did you manage to solve this?
  11. D

    Download & Save MP3 via URL Link

    In addition to the suggestions provided above, you may also try using a different method, like instead of: Set objHTTP = CreateObject("Microsoft.XMLHTTP") use Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP") But the API approach set out on theDBguy's blog post should download it for you...
  12. D

    How to activate a ribbon?

    Again, here, you're replying to my comment, but it's not project, and I didn't get it sorted. I believe you're thinking of someone else?
  13. D

    How to activate a ribbon?

    That wasn't me - that was Danishtj who was discussing Display Options at post #23.
  14. D

    How to activate a ribbon?

    Did it work?
  15. D

    How to activate a ribbon?

    Hi - sorry for not getting back to you sooner. Monday was... well... Monday! :-) So I tried again earlier and wasn't getting anywhere, then on a hunch, I went and changed the tab name (id, etc) from Home to (randomly) "Website". It now seems to work... I can't claim that I fully understand...
  16. D

    How to activate a ribbon?

    Well, I can get it to switch between the Login and Print tabs easily enough, but for whatever reason, not to the Home Tab. I'll take a look on Monday when I'm back from the weekend.
  17. D

    How to activate a ribbon?

    On the off-chance that it might be helpful to you, or to so someone else who comes across this thread: Sub ActivateTab() ActivateRibbonTab "Print" End Sub Private Function ActivateRibbonTab(ByVal TabName As String) As Boolean '...
  18. D

    Ketanji Brown Jackson Nominated to the US Supreme Court

    It appears that it was a nomination to the Court of Appeal that Biden filibustered, and not to the Supreme Court (link). I would add that it is not as though Biden singlehandedly-blocked the nomination; he voted against Justice Brown's appointment along with the rest of the Democratic caucus...
  19. D

    Setting extended property values for external files using VBA

    I'm very sorry - I thought I had posted an update earlier in the week. What I thought I had sent was items 2 and 3 below, but they were since overtaken with the following, far more relevant point. It's not a short note, but I thought I'd give you more detail on the off-chance it might help get...
  20. D

    Open Notepad and Find/Replace

    Thank you! I saw that Eugene-LS had done it, so I followed suit. I easily succumb to peer-pressure. :-)
Back
Top Bottom