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