Answers in-line. Thanks
Webster > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Joshua Delaughter > Sent: Monday, April 06, 2015 10:53 PM > To: [email protected] > Subject: Re: [powershell] Working with Web Query Files > > Could the last line possibly kill other Excel instances that might be running? It will kill every instance of Excel running in the user's session. > Does the Quit method in the second to last line not kill the process? Not every time. Which makes me realize that I forgot to implement some code I had tested that looped through and killed all the Excel processes. In my lab, I had 12 Delivery Groups and after processing all 12 groups, I had 12 Excel processes running. I thought I had copied my test code into my script. Looks like I forgot to do that. > > Is there a way to get the PID for the particular instance of Excel that this > snippet starts instead? Yep, shown in another reply. > > Sent from my iPhone > > > On Apr 6, 2015, at 5:40 PM, Sean Martin <[email protected]> > wrote: > > > > Good afternoon, > > > > I've been working on a Powershell script to create/update Mail Contacts in > Exchange based on information stored in our SharePoint site. This may be > trivial to some of you, but I thought I would share for those who are > relatively new to Powershell such as myself. > > > > Saving the list from Sharepoint to a Web Query File (.IQY) allows for the > presentation of current data each time the file is opened. I had a hard time > figuring out how to work with the file directly, and didn't have the option of > running the script on our Sharepoint server or remotely against it, so I used > the following to save the content as a CSV. > > > > # Convert Web Query File to CSV > > $xl = New-Object -C Excel.Application -vb:$false $xl.DisplayAlerts = > > $False $iqy = $xl.Workbooks.Open('<path to IQY file'>) > > $iqy.SaveAs('<Path for saved CSV file>', 6) > > $iqy.Close($false) > > $xl.Quit() > > Get-Process Excel | kill > > > > I can't take credit for the above, but it did take some time track it down > > so I > thought sharing it might help someone else avoid the research time. > > > > - Sean ================================================ Did you know you can also post and find answers on PowerShell in the forums? http://www.myitforum.com/forums/default.asp?catApp=1
