ADS info via VBA 64bit

**TML59** · 02-05-2024, 11:39 PM

New here and posted this in another forum earlier, there was good help but I'm stuck, so hopefully it's OK to try this here

I’ve been using CStreams code from Karl E. Peterson (https://classicvb.net/samples/Streams/) in Excel VBA.
I moved to MSO365 64-bit and I am getting errors in my code. I can fix some of these, but as I also use Karl's CStreams Class module, I believe that one needs adoption for 64 bit as well. Regretfully, that requires s0o many changes that, to date, I can't get this to work.

Now, I'm not bound to the CStreams code of course: any code that I can use in 64-bit VBA (Excel) that will allow me to read and delete (some) ADS information from potentially thousands of files would be also very much appreciated.

**TML59** · 02-12-2024, 06:35 PM

**DocAElstein** · 02-13-2024, 03:46 AM

Hi TML59
Welcome to ExcelFox

We are active, but there are not so many people passing here just now. (Notifictions of postings are also not working so well, so its easy to miss posts and replies)

Sorry you have no answer. I originally took a look just after you posted but I have no knowledge of that stuff.
I think there are occasionally people with some of this VB knowledge passing here at eileenslounge.com
https://eileenslounge.com/viewforum.php?f=30
In fact there seems to be a recent post that may be along the lines of what you are looking for
https://eileenslounge.com/viewtopic.php?f=30&t=40538

(You could also try one of the very active Excel forums such as excelforum.com, but they tend to be a bit stuck in their Excel and VBA ways, whereas eileenslounge.com are a bit less tunnel visioned and have a broader knowledge base).

Alan

**TML59** · 02-13-2024, 01:25 PM

Originally Posted by DocAElstein

In fact there seems to be a recent post that may be along the lines of what you are looking for
https://eileenslounge.com/viewtopic.php?f=30&t=40538

Thanks, appreciated. And the quote: that's the post in another forum I mentioned (so that's me)

**DocAElstein** · 02-14-2024, 01:40 AM

Originally Posted by TML59

.....that's the post in another forum I mentioned (so that's me)

Lol,

( there is also a VB forum, https://www.vbforums.com/forum.php , but I have little experience there, I don't know what sub forum there would be relevant for your problem )

Alan

**TML59** · 02-14-2024, 04:18 PM

Originally Posted by DocAElstein

Lol,

( there is also a VB forum, https://www.vbforums.com/forum.php , but I have little experience there, I don't know what sub forum there would be relevant for your problem )

Alan

Thanks, I'll post there too (in the VB6 forum)

**TML59** · 02-15-2024, 06:48 PM

This is to let you know that someone "fafalone"in the "vbforums"-forum you pointed me to helped me out very quickly and converted the original CStreams 32bit code in code that also runs in a 64 bit environment!

**DocAElstein** · 02-15-2024, 08:55 PM

That’s great, thanks for letting us know, - that may help someone passing in the future,
(here’s the link for future reference https://www.vbforums.com/showthread....=1#post5632759
https://www.vbforums.com/showthread.php?902687-ADS-info-via-VB6-VBA-64bit&p=5632759&viewfull=1#post5632759
https://www.vbforums.com/showthread....it#post5632759
https://www.vbforums.com/showthread.php?902687-ADS-info-via-VB6-VBA-64bit#post5632759 )

Alan

( P.S. cross post is at Eileens Lounge https://eileenslounge.com/viewtopic.php?f=30&t=40538 )

**TML59** · 07-05-2024, 09:33 PM

Originally Posted by Shiftyshell

Switching to 64-bit Excel can definitely cause some headaches with older VBA code, especially when dealing with external libraries like Karl E. Peterson's CStreams. If you're open to alternatives, have you looked into using native VBA file handling methods for reading and manipulating ADS?

Thanks, as indicated above, I did receive working 64-bit VBA code (adapted from Karl E. Peterson's CStreams code, which solved my problem).

FWIW, I'd be interested to hear how native VBA file handling code that manipulate ADS streams, so if you'd have more info that would be nice.

**Muhammad Awais** · 07-13-2024, 03:43 PM

Switching to MSO365 64-bit can really throw a wrench into existing VBA code, especially with older libraries like CStreams. Adapting code for 64-bit compatibility is indeed a challenge, and sometimes starting fresh with a 64-bit compatible solution might be less of a headache.