Search results

The following seems to strip the offending characters from the file. Does this work for you? You should only need to update the file path in the principal subroutine, CleanTextFile.

Ah I see. Unfortunately, I don't have my personal laptop to hand (therefore, no Access) so wasn't able to check whether or not my DownloadComplete approach worked when changing the properties with your program. I can check when I get home, but I'm afraid I don't know off the top of my head. The...

I just find it really odd that MS would make the setting of these extended properties: (a) such a convoluted process (requiring an external DLL that is extremely difficult to find - for 64-bit, at least); (b) seemingly impossible (for ACCDB, at least). As for the Webbrowser settings, the best...

I checked the properties point just now. I had originally set the Title and Keywords properties, but to double check, I also wrote to the Manager, Company and Comments properties just now. I was able to access these properties by loading the PublisherTest file you provided, and selecting the...

You're absolutely right about vbOKOnly - Thank you for pointing that out. I should've mentioned it, but I just wanted to demonstrate what the return value would otherwise be in case it was helpful. As to StrPtr - it is necessary for MessageBoxTimeoutW, which is a unicode-enabled API. You've...

If you're not averse to using an API, I just tested the following so fingers-crossed, it should work. It uses the API - MessageBoxTimeoutW (unicode compatible), and I have included both 32- and 64-bit declarations: #If Win64 Then Private Declare PtrSafe Function MessageBoxTimeoutW Lib...

Hi I know that you posted this some time ago, and that you've likely moved on from it, but I just wanted to thank you for posting the project. I have had a horrible time trying to find any information about this (specifically for VBA) until I came across your post. I was familiar with the...

Please forgive me - I'm not experienced in Access VBA (I work mostly with Excel VBA/Outlook VBA), but I would have thought that you could add controls to the VBIDE (the VBA side) through using the Microsoft VBA Extensibility 5.3 library?

That's really strange. What version of Chrome / ChromeDriver are you using? I'm not sure I can but I can see if I maybe try and reproduce the error?

I don't have any experience with WebDriver, but have you tried using ChromeDriver? I tend to find with SeleniumBasic the standard problem is when there is mismatch between the version of Chrome being used and the chromedriver.exe file that is installed.

This looks amazing! I use TTS a fair bit because I get tired of reading all day every day, so I've been on the hunt for natural sounding TTS options. In my wildest dreams, I would love to be access the voices being used in the Edge Read Aloud function - the Natural Online language voices...

Of course, sorry. I attach 1 x bas file (in txt format) comprising the API-related functions. The key function is ThumbnailPicFromFile - it can take 3 arguments: (1) FilePath (string); (2) Width (long), and (3) Height (long), and returns a StdPicture data type. That being the case, you can...

Sorry - I appreciate that this thread is now a few weeks old, but is this the sort of thing you're referring to? It uses the WIN32APIs to extracts the low-res thumbnail saved with the file and then displays it in an imagebox. If the file did not save with a thumbnail, then the associated...

I don't see Microsoft replacing VBA with Python, and I still haven't heard much about the so-called 'VBA Killer' - is it called OfficeJS now? For my part, the fact that OfficeJS cannot engage with the local computer is a critical problem - what I mean is that it can't go through the files and...

One option could be to use the ImageMagick COM Object. It's free, easy to use, and this kind of work is exactly what it was made for. Failing that, it would be less than ideal, but could you not conceivably use the WIA COM Object to manipulate the image? I checked and of all the image...

Hi, I'm Dan. I use VBA daily for maybe the past 5 years - this mostly centres around Excel, Outlook and Word and very rarely Access. My current VBA interests are - Ribbon XML and Win32 APIs (mostly GDI/GDI+). Since just before the start of the pandemic, and all throughout lockdown, I have been...

I would maintain that they are fundamentally different. It certainly wasn't an immediate response, and it decimated the gay community. It took most of the 80s before any real momentum gained traction on the front and, depending on which country one is in, one is still in a struggle on the...