windows script host for NT reading Excel

viper · Feb 19th, 2002, 11:23 PM

I am working on a spreadsheet for purchases. Is there any possible way for a dos based script host reading the cells of my spreadsheet? Really I'm trying to eliminate the dos part altogether but that will further down the road but right now we are entering our invoices twice, once in my spreadsheet and then again in the dos program at work so that individual items we purchase can be tracked in our inventory system. I just want our inventory system to be able to read my spreadsheet and pull the data from it. My be a stretch but thought I'd ask.

Damon Ostrander · Feb 20th, 2002, 11:05 PM

Hi Viper,

Are you by any chance the Vindow Viper? Oh, never mind.

Can your DOS program read data from a text file? If so, no problem since Excel VBA can write data to text files quite easily. See the VBA helps for file I/O statements like Open, Print #, Write #, EOF(), Close, etc.

If the DOS application can't read from a text file I think you are out of luck.

Feb 20th, 2002, 11:05 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Viper, Are you by any chance the Vindow Viper? Oh, never mind. Can your DOS program read data from a text file? If so, no problem since Excel VBA can write data to text files quite easily. See the VBA helps for file I/O statements like Open, Print #, Write #, EOF(), Close, etc. If the DOS application can't read from a text file I think you are out of luck. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 11:23 PM	#1
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	I am working on a spreadsheet for purchases. Is there any possible way for a dos based script host reading the cells of my spreadsheet? Really I'm trying to eliminate the dos part altogether but that will further down the road but right now we are entering our invoices twice, once in my spreadsheet and then again in the dos program at work so that individual items we purchase can be tracked in our inventory system. I just want our inventory system to be able to read my spreadsheet and pull the data from it. My be a stretch but thought I'd ask.