Consulting

Results 1 to 7 of 7

Thread: VBScript deprecated

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    VBScript deprecated

    To my fellow VBA developers. If you have projects that depend on the Scripting Runtime library, beware. VBScript is going to be turned off and subsequently deprecated on Windows clients. Things like the Dictionary object, the FileSystemObject and other useful libraries will no longer be available and cause compile errors in your code. It isn't happening soon, but at least you'll have time to plan ahead: https://techcommunity.microsoft.com/...s/ba-p/4148301
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,180
    Location
    Are they (Microsoft) offering an alternative?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    They mention PowerShell and JavaScript. No idea how as neither offers VBA integration as far as I'm aware.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  4. #4
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,180
    Location
    Oh no..... not more stuff to peruse and muddle through.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  5. #5
    It does look like we can use Powershell. But no idea how or what is available precisely.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  6. #6
    Looks like it isn't all that bad, see this comment: https://techcommunity.microsoft.com/...ght/true#M7265
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  7. #7
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,744
    Location
    Quote Originally Posted by Jan Karel Pieterse View Post
    Looks like it isn't all that bad, see this comment: https://techcommunity.microsoft.com/...ght/true#M7265

    I had a hard time following some of that

    I use VBS for many stand alone scripts to replace my BAT files since I find VBS and WSH easier to work with than batch or Powershell

    I looked at PS a little while ago and didn't really like it -- too complicated and the commands were insufficiently VBA like

    Added:

    I use Scripting.FileSystemObject and Scripting.Dictionary and Shell.Application as well as a lot of .NET structures I learned about from http://www.snb-vba.eu/
    Last edited by Paul_Hossler; 05-23-2024 at 05:21 PM.
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Tags for this Thread

Posting Permissions

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