Search results for query: *

Hello all I don’t know if this is possible but I am trying to take several CSV files and convert them into a single pre existing workbook. The pre existing work book has a summary sheet that will pull information from all the imported sheets. The basic work flow is Report is dumped into a dir...

Thank you markdmac I have been researching it and seen others try to make cmdlets for PowerShell to make it work but when I try it it errors out

Hello All I have a PowerShell script that takes a txt file that is output from our monitoring software sorts it by headers and converts it to a CSV file. my issue is that I need this file in xlsx format and I do not have Excel installed on the server. does anyone know of anyway to do this?

@SkipVought yes that is correct I got it working using VBS to call excel. (see code below) my issue is that the company has removed excel from the servers for lic. reasons is there a way to do the same thing with out calling excel. I have been looking at PowerShell as well. basically need to do...

hello all I have a report that is run from our monitoring software. I have a batch file that converts the report from a txt file to a CSV file. the number of items in the report may change but not the headers. my goal is after the batch file converts the file it will run the VBS script to sort...