Jump to content
Banner by ~ Ice Princess Silky

Brony Number 42

Subscriber
  • Posts

    4,493
  • Joined

  • Last visited

Everything posted by Brony Number 42

  1. Do you ever write code to write code? Like you need a big block of code that repeats but changes 1 thing?

    1. CypherHoof

      CypherHoof

      Yes, but not for that reason. had an access database that needed to pull some data from the amazon api, but the amazon api is very hard to write code against from vba; however, the powershell library for the amazon api is easy to use and well documented, so cue one routine to output a powershell script with the calls to use, that opens the access database as an object, then writes the results of the api calls back into tables there....

    2. Brony Number 42

      Brony Number 42

      I never learned how to use APIs. I'm just a casual VBA user.

    3. CypherHoof

      CypherHoof

      You can use a fair few apis from inside vba, and most office apps will autocomplete syntax for you, provided you have declared the objects (Dim objname AS objtype) and it knows which library dlls those objects belong to.

      AWS doesn't have a scriptable activex object though (which isn't surprising really, MS have been pushing people off VB and onto powershell for ages now)

  2. I'm going to start Eye Of The Beholder and see if I can edit the save file.
  3. You just had that qued up and waiting. 124
×
×
  • Create New...