Club PA 2.0 has arrived! If you'd like to access some extra PA content and help support the forums, check it out at patreon.com/ClubPA
The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

Changing Excel VBA to VBS

halkunhalkun Registered User regular
Not sure of this is the place to put this...
So at work I wrote a slick app in excel using VBA. Sadly when I submitted it to our compliance people, they said because it was a macro, I couldn't deploy this really useful thing to our team. I was told I can write it as a VBS script and call excel, and that would be OK... But looking at VBS I'm missing some pretty bare-bones functionality. The big one is creating forms. I can seem to call Excel VBA calls, but that's no good if I can't make a form first. Any ideas on how to pull this off?

wVo0Rgr.png
halkun on

Posts

  • JustforspiteJustforspite Registered User regular
    I've done a bit of VBA work with Excel and Word but this is a tough one. For starters trying to research this is going to be hard as most results will default to thinking you want VBA instead of VBS. Any chance you could write it in something else as a standalone app that does all of the user input/forms etc and then creates an Excel file after handling all of the UI?

    Thanks to @pkkaos for the awesome avatar!
  • halkunhalkun Registered User regular
    I actually was able to accomplish this. The conversion was easier then I thought and was able to use the normal input dialog box as input and generated a webpage as output.

    The languages are almost exactly the same, save for some object management.

    wVo0Rgr.png
    Justforspite
Sign In or Register to comment.