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.
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.