WOW... I've finally found a beacon of hope :-).

Q: Can I use "something" to access a file using EXCEL, then use some
"wizardry" to make changes to the file?

Let me start with, I have been a mainframe programmer for about a hundred
years, but I know next to nothing about Excel or the PC/LAN environment. But,
with some research I have figured out there may be some way to automate a
process that my team does many times a day.

I have created a bunch of mainframe stuff that results in a comma delimited
..txt file being TCPIP'ed to a LAN directory. Once it is on the LAN I open
EXCEL and manually do a series of steps. What I am hoping to accomplish is to
use WMI to watch the LAN folder to see when a new .txt file is TCPIP'ed into
it. Then I want to "magically" access EXCEL and in the background, open the
..txt file, and apply the manual steps (which I'll outline below). I have
already played with WMI a bit and have the watching the LAN directory for new
..txt files working, but I have no clue how to access EXCEL and apply the
manual steps.

Here are the manual steps:

+++ Open EXCEL
+++ File/Open/ (open .txt file to be modified)
+++ Page 1 of Text Import Wizard comes up and I select "Delimited" Next
+++ Page 2 of Text Import Wizard comes up and I uncheck "Tab" and check
"Comma" Next
+++ Page 3 of Text Import Wizard comes up and in the Data Preview I select
all columns, and select "Text" as the Column data format Finish
+++ Excel now shows the data. I do Ctrl+A to Select All
+++ Format/Column/AutoFit Enter
+++ File/Save As
+++ Change Save As Type to "Microsoft Excel 97 - Excel 2003 & 5.0/95
workbook(*.xls)" Save

So, that's it. Am I out of my mind, or is there a way to do that?