windows script host for NT reading Excel

viper

Active Member
Joined
Feb 15, 2002
Messages
382
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.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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.
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top