<div>
<div class="content wysiwyg-content">
I have a text file that is generated from a system. &nbsp;I edit the file daily with a macro and submit my revised text file to the appropriate department. &nbsp;I thought i had conquered my lazyness by getting my macro to work flawlessly. &nbsp;i did not knoweth what i thinkethed at the time. &nbsp;I need to be lazier.<br />
<br />
This does not have to be powershell but i would like an icon (probably batch or ps) that i can double click and have excel open the text file. &nbsp;edit the text file and then save it back out as a .prn file. &nbsp;is there anyway to do this.<br />
example.<br />
i have a file called 1.txt &nbsp; &nbsp;i have a xlsm file 2.xlsm that contains the macro... &nbsp; CreateIntegrationFile<br />
can i write a code that will open the 2.xlsm file, then run the create integration macro, and then save the results.
</div>
</div>


I have a text file that is generated from a system.  I edit the file daily with a macro and submit my revised text file to the appropriate department.  I thought i had conquered my lazyness by getting my macro to work flawlessly.  i did not knoweth what i thinkethed at the time.  I need to be lazier.

This does not have to be powershell but i would like an icon (probably batch or ps) that i can double click and have excel open the text file.  edit the text file and then save it back out as a .prn file.  is there anyway to do this.
example.
i have a file called 1.txt    i have a xlsm file 2.xlsm that contains the macro...   CreateIntegrationFile
can i write a code that will open the 2.xlsm file, then run the create integration macro, and then save the results.

using powershell to automate some excel functions

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.