I want to add simple values to a bi-monthly inventory report from the
command line (cmd.exe), if possible. The OS' are W2k and XPPro and
Excel/Office versions 2000/2003. New values are calculated by a console/DOS
app, so, if I can add them directly to the xls, that's another step done in
my goal of automating the entire report process.

Can it be done?

Martin

Suggest that you use cmd.exe ( or a .bat file) to create a .txt file.

It is then easy to open the .txt file under VBA and populate cells.
--
Gary''s Student


"Martin" wrote:


I want to add simple values to a bi-monthly inventory report from the
command line (cmd.exe), if possible. The OS' are W2k and XPPro and
Excel/Office versions 2000/2003. New values are calculated by a console/DOS
app, so, if I can add them directly to the xls, that's another step done in
my goal of automating the entire report process.

Can it be done?

Martin

That would work if no user interaction to start/close Excel or VBA is
required. That's where I don't have the knowledge to proceed without help.

I can create a file, or environment variables, and make an association to
Start Excel, but then...

Is there a FAQ or list of Tips-n-Tricks I should be reading??


"Gary''s Student" wrote in message
...
Suggest that you use cmd.exe ( or a .bat file) to create a .txt file.

It is then easy to open the .txt file under VBA and populate cells.
--
Gary''s Student


"Martin" wrote:


I want to add simple values to a bi-monthly inventory report from the
command line (cmd.exe), if possible. The OS' are W2k and XPPro and
Excel/Office versions 2000/2003. New values are calculated by a
console/DOS
app, so, if I can add them directly to the xls, that's another step done
in
my goal of automating the entire report process.

Can it be done?

Martin