dotprogrammer
New Member
As shown below I need to automate opening/saving/closing excel after pasting data from .txt files.
The files are actually .cty files but will be opened using notepad.
The first excel file listed corresponds to the first .cty file, and the second excel file to the second .cty file, etc.
The excel file contains 4 tabs but I need the data pasted into two of those tabs, in cell A2 for both tabs as well. The tabs are titled "M6RURSpdVMT" and "M6URBSpdVMT". After pasting into cell A2, the data needs Text to Columns applied to it. (For Text to Columns it needs to be "Fixed width" and then "Finish").
Afterwards, the excel file can be saved and closed and then move onto the next set of files.
Please let me know if you need more details, thanks!
The files are actually .cty files but will be opened using notepad.
The first excel file listed corresponds to the first .cty file, and the second excel file to the second .cty file, etc.
The excel file contains 4 tabs but I need the data pasted into two of those tabs, in cell A2 for both tabs as well. The tabs are titled "M6RURSpdVMT" and "M6URBSpdVMT". After pasting into cell A2, the data needs Text to Columns applied to it. (For Text to Columns it needs to be "Fixed width" and then "Finish").
Afterwards, the excel file can be saved and closed and then move onto the next set of files.
Please let me know if you need more details, thanks!