Print Page - Using Winbatch as a front-end to Excel

Title: Using Winbatch as a front-end to Excel
Post by: pguild on August 19, 2020, 01:55:22 PM

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?

Title: Re: Using Winbatch as a front-end to Excel
Post by: td on August 19, 2020, 02:18:15 PM

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.

Title: Re: Using Winbatch as a front-end to Excel
Post by: stanl on August 20, 2020, 02:32:50 AM

probably start here - plenty of code examples

https://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+Tutorials/OLE~TUTORIAL+Automating~Excel~Tutorial.txt

Title: Re: Using Winbatch as a front-end to Excel
Post by: pguild on August 20, 2020, 09:49:59 AM

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)

WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: pguild on August 19, 2020, 01:55:22 PM