is it possible to add data to cells from the command line?

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

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.
 
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??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save data from Notebook: copying to the USB stick using Linux and the command line 0
command-line ftp from Access? 2
Is it possible to change a Sheet reference in a formula? 1
Launch command-line utility from DUA without showing a CMD.EXE win 1
what is the best way to pull in external data from SQL table 3
Is it possible to Calculate a single worksheet at a time? 1
Need command line to change the results in a cell from #DIV/0 to 0 4
UDF weeks of inventory calculation - lost on how to create this lo 3

Back
Top