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
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
They mention PowerShell and JavaScript. No idea how as neither offers VBA integration as far as I'm aware.
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
It does look like we can use Powershell. But no idea how or what is available precisely.
Looks like it isn't all that bad, see this comment: https://techcommunity.microsoft.com/...ght/true#M7265
Originally Posted by Jan Karel Pieterse
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
Reply With Quote
