Using Winbatch as a front-end to Excel

Started by pguild, August 19, 2020, 01:55:22 PM

Previous topic - Next topic

pguild

I would to make a friendly dialog in Winbatch that prompts user for data. Then I want to put that data into a row in a spreadsheet. Any ideas?

I'm thinking of maintaining a csv file.
I could build a regular Excel spreadsheet first and then export it to a csv file.

Winbatch could append data to this file. The Excel app could then import the csv file. Winbatch might launch Excel and then send keystrokes to Excel to take care of the import.   

Your thoughts?

td

Search on the term "excel" in the Tech Database.  You will need to do some digging but there are multiple ways to accomplish the task you have set out without resorting to the likes of the SendKey function.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade


pguild

Thanks! Lots of useful stuff in there.  This could make things really slick. For now, I'll take the easy road.  But I appreciate your help! 8)