-
Posts
4,493 -
Joined
-
Last visited
Content Type
Profiles
Forums
Character Archive
Frequently Asked Questions
Equestrian Empire Character Archive
Golden Oaks Memorial Library
Pony Roleplay Characters
Events
Blogs
Everything posted by Brony Number 42
-
Do you ever write code to write code? Like you need a big block of code that repeats but changes 1 thing?
-
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....
-
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)
-