Search results

Thank you for posting the link - I would've if I could've, but at this rate, it won't be until 2028 before I can post anything resembling a URL. I hope you find it helpful. ONe of my side projects has been making a music player/database that required a lot of metadata work, but it's been a fun...

As always, I'm painfully late to the party, and given that it's been nearly a month it's probably a safe bet that you've already solved your problem. But on the off-chance it's helpful to anyone else - it is possible to change the ID3 tags (the MP3 metadata) of a file with VBA. There are two...

If you have Access (and judging from your comment earlier about using Powerpoint), I'm going to take a stab-in-the-dark and assume you also have access to MS Word? If so, you could always just load the PDF into Word, and then export the relevant page(s) of the PDF as PNGs that way....?

There is an equivalent technique that inserts the PDF as an OLEObject onto a worksheet in Excel, and it kinda works if all you are after is to export the first page of the PDF. I may have misunderstood, but can this method export more than just first page?

I've never come across this before, it looks like it could potentially be really helpful - But I can't see where the free/community edition might be.

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.

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...

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...

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"

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...

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

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...

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...

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

Did you manage to solve this?

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...

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?

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

Did it work?

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...