trying to make a powershell/vba tool

[suicidalfranco]

doing a mechanical task at work, and an idea popped in mind: what if i tried to made a tool that took off at least half of the job for me.

After some long consideration, while still doing my work, i thought that the fastest way, and by fast i mean shortest code write up possible, was too:

1. copy a text in a cell on excel

2. paste it to filesearchEX (network search program my work place uses)

3. repeat till end of the table on the sheet

 

that way i'll end up with multiple instances of filesearch opened and all i would have to do is look at the search results

 

but the bit where i'm stuck is point 2. Can i do that with either VBA or powershell?

[Guest]

Dont know how filesearchex looks like but u can save excel file as csv and retrieve data easily with PS. 

[Levisallanon]

First of all you should check this table to see if your project is worth it ;).

 

From what I see step 1 and 3 should be possible with both PS and VBA. But step 2 is probably hard. Unless it has a cli interface or api you can interface with.

[suicidalfranco]

3 minutes ago, Levisallanon said:

cli interface

yeah, what i've been googling for the past hour. Don't think it has it

 

and on the xkcd comic: first and proly last time on this task, will probably take me the whole day if not more, even if i have to finissh it tomorrow i'd rather have a tool that makes it less painful than it already is. Damn boring as F

[suicidalfranco]

10 minutes ago, deXxterlab97 said:

Dont know how filesearchex looks like but u can save excel file as csv and retrieve data easily with PS

think of it as file explorer, but just with the search utility and no clutter

 

[Levisallanon]

6 minutes ago, suicidalfranco said:

yeah, what i've been googling for the past hour. Don't think it has it

 

and on the xkcd comic: first and proly last time on this task, will probably take me the whole day if not more, even if i have to finissh it tomorrow i'd rather have a tool that makes it less painful than it already is. Damn boring as F

well then you will need to interact with the gui itself.
It's possible but not nice ;).
Think this blog post will help you underway:
https://blogs.technet.microsoft.com/heyscriptingguy/2011/01/10/provide-input-to-applications-with-powershell/

Else you might be helped by just a simple macro recorder, don't know the specific situation:
http://www.mouserecorder.com/

[suicidalfranco]

24 minutes ago, Levisallanon said:

well then you will need to interact with the gui itself.
It's possible but not nice ;).
Think this blog post will help you underway:
https://blogs.technet.microsoft.com/heyscriptingguy/2011/01/10/provide-input-to-applications-with-powershell/

damn it....

...

scipt execution is disabled. Damn IT peeps! always making my life hard T-T

 

[Guest]

3 hours ago, suicidalfranco said:

damn it....

...

scipt execution is disabled. Damn IT peeps! always making my life hard T-T

 

set-executionpolicy remotesigned

 

[suicidalfranco]

7 minutes ago, deXxterlab97 said:

set-executionpolicy remotesigned

 

mmh...

will give it a try tomorrow

[suicidalfranco]

14 hours ago, deXxterlab97 said:

set-executionpolicy remotesigned

 

yeah, didn't help, needs to run as admin to modify registry key