#1 25 May 2010 19:47

Swing Daddy
Registered: 25 May 2010
Posts: 1

New Newbie - Do I ask too much, more than a lot?

I heard about this "thing" called PowerShell and was hoping I could use this tool to debug other programs while they are running. 

In particular, how can I (or is it just "Can I"?) use PowerShell to query variables or objects in a VBA project w(hile it is running a user form interface)?  For me, this could be useful because I find debugging my VBA project to be painful, given that everything must be displayed within one darned overall window.  I hate that!  Maybe I am ignorant of known VBA IDE techniques that open the IDE in multiple windows, but I know of none.  I would prefer to be able to use a second window, thus my particular interest in PowerShell.  Regardless, can PowerShell be easily used to access variables or other objects of a VBA project?

Thank you so much (only if you help, of course  big_smile).  I would spend 10 hours learning PowerShell for my purposes, but I don't want to forge ahead, only to find out it can't do things for which I had envisioned using it.  Other helplful sugesstions are welcome, but please no insults.  If this stuff is TRULY covered in an FAQ, I can handle that, too.  Ideally, just an example or two would probably get me on my way, like a command to access my userform properties, or a variable value within a particular function or procedure.


Swing Daddy


#2 28 May 2010 12:16

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 1,070

Re: New Newbie - Do I ask too much, more than a lot?

You can call a powershell script from VBA and you can write powershell scripts that drive MS Office, but being primarliy command line I don't think powershell is going to interact with the MS Office VBA IDE in any useful way.


Board footer

Powered by FluxBB