Blog

We start by using the preexisting foreach command we then create an IF statement to test the connection. The trick with IF statements is the condition directly after the statement is always $True. So you have to write it accordingly.

We are continuing our new series that answers common questions, or questions that have been asked about PowerShell. In this post we talk about how to combine multiple text files into one xlsx file. What we intend to provide is one of the many, many ways you can accomplish these tasks within PowerShell.