windows script host for NT reading Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: windows script host for NT reading Excel

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com