Results 1 to 10 of 10

Thread: ADS info via VBA 64bit

  1. #1
    Junior Member
    Join Date
    Feb 2024
    Posts
    6
    Rep Power
    0

    ADS info via VBA 64bit

    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.
    Last edited by DocAElstein; 02-06-2024 at 01:29 AM.

  2. #2
    Junior Member
    Join Date
    Feb 2024
    Posts
    6
    Rep Power
    0
    Last edited by DocAElstein; 10-04-2024 at 10:23 PM.

  3. #3
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    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
    Last edited by DocAElstein; 02-13-2024 at 03:50 AM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  4. #4
    Junior Member
    Join Date
    Feb 2024
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by DocAElstein View Post
    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)

  5. #5
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    Quote Originally Posted by TML59 View Post
    .....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

  6. #6
    Junior Member
    Join Date
    Feb 2024
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by DocAElstein View Post
    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)

  7. #7
    Junior Member
    Join Date
    Feb 2024
    Posts
    6
    Rep Power
    0
    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!

  8. #8
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,422
    Rep Power
    10
    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 )
    Last edited by DocAElstein; 02-17-2024 at 09:12 PM.

  9. #9
    Junior Member
    Join Date
    Feb 2024
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by Shiftyshell View Post
    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.

  10. #10
    Junior Member
    Join Date
    Apr 2019
    Posts
    1
    Rep Power
    0
    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.

Similar Threads

  1. Replies: 21
    Last Post: 07-09-2023, 05:20 PM
  2. DATA SHEET UPDATE INFO CODE
    By richardswaim in forum Excel Help
    Replies: 0
    Last Post: 06-05-2016, 04:14 AM
  3. Replies: 4
    Last Post: 09-25-2014, 03:12 PM
  4. Info: different Value !
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 04-22-2012, 04:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •