AHK to run PowerShell command Topic is solved

[fenchai]

In my search for a good CSV viewer. I found Windows has it's own CSV VIEWER which is by far the best I have seen.

Now I just needed it to be launched via AHK. How?

The code is simply.

Code: Select all

 Import-Csv yourfile.csv |Out-GridView

[remixyz]

Code: Select all

SetKeyDelay, 0, 0

Run, C:\WINDOWS\system32\WindowsPowerShell\v1.0\powershell_ise.exe
Sleep, 3000
string=Import-Csv yourfile.csv |Out-GridView
clipboard = %string%
ControlSend,, {Enter},ahk_exe powershell_ise.exe
Send ^v
Sleep, 200
ControlSend,, {Enter},ahk_exe powershell_ise.exe

Return

I don't know if that was what u want.

[tmplinshi]

Code: Select all

Run, powershell -NoExit -Command "Import-Csv D:\Desktop\yourfile.csv | Out-GridView"

[fenchai]

Code: Select all

Run, powershell -NoExit -Command "Import-Csv D:\Desktop\yourfile.csv | Out-GridView"

damn, this popped...

https://i.imgur.com/3HdyakX.png

[tmplinshi]

It's because of the spaces in your path. You can either use:

Code: Select all

Run powershell -NoExit -Command "Import-Csv \"D:\Desktop\your file.csv\" | Out-GridView"

or:

Code: Select all

Run powershell -NoExit -Command "Import-Csv 'D:\Desktop\your file.csv' | Out-GridView"

[fenchai]

What about using variables? because I have multiple computers so different filepaths.

I figured it out thanks

[divanebaba]

It's because of the spaces in your path. You can either use:

Code: Select all

Run powershell -NoExit -Command "Import-Csv \"D:\Desktop\your file.csv\" | Out-GridView"

or:

Code: Select all

Run powershell -NoExit -Command "Import-Csv 'D:\Desktop\your file.csv' | Out-GridView"

Cool stuff.
Is it possible to determine another delimiter than semikolon or comma?

[LAPIII]

Where can I see a list of options like -NoExit and -Command?

[RussF]

Google "powershell command line options"

Russ