2

Basically from a input provided network path (e.g "\SERVER\SHARE\") i want to copy a specific Excel file to my desktop and run it automatically. Problem is that on my desktop there are other Excel files containing the letters ZZZ. Any ideas? Thank you!

$title = "Copy ZZZ to Desktop"
$zzzpath = read-host Paste ZZZ path here
copy-item "$zzzpath\*ZZZ*.xlsx" "C:\Users\%username%\Desktop\"
Invoke-Item C:\Users\%username%\Desktop\*ZZZ*.xlsx
Crit Scratch
  • 43
  • 1
  • 10

2 Answers2

2

You can pipe the output of Copy-Item to your Invoke-Item, forcing the former to pass its output to the latter (via -PassThru):

$title = "Copy ZZZ to Desktop"
$zzzpath = Read-Host Paste ZZZ path here

Copy-Item "$zzzpath\*ZZZ*.xlsx" "C:\Users\%username%\Desktop\" -PassThru |
    Invoke-Item
Efran Cobisi
  • 6,138
  • 22
  • 22
  • Thank you Sir!!! Exactly what i needed :) I was testing using -passthru and pipe but didn't understand how to apply it correctly. I want to correct something i missed, the correct input for user desktop is "$Env:USERPROFILE\desktop\" (%username% is for batch). – Crit Scratch Apr 19 '13 at 06:55
0

I think I would have done something like this: 

$path = read-host "Enter/paste path"
$localdesktop = $env:userprofile, "\desktop" -join ("")

$xlsdoc = Get-ChildItem -path $path | where {$_.Name -match ".xlsx$" -and $_.Name -match "ZZZ"}

Copy-Item -path ($xlsdoc.FullName) -destination $localdesktop

$copiedxls = Get-ChildItem -path $localdesktop | where {$_.Name -match ".xlsx$" -and $_.Length -match $xlsdoc.Length}

Sleep -s 5

start $copiedxls.FullName

start $copiedxls

Edit: I use the '.lenght' property to compare filesize. This is how I determine wich "zzz.xlsx" to start.

Erlend.

erlwes
  • 1
  • 1