+ Reply to Thread
Results 1 to 3 of 3

script for writing excel values into specific locations in a text

Hybrid View

whiz999 script for writing excel... 06-01-2009, 09:56 PM
Andy Pope Re: script for writing excel... 06-02-2009, 05:23 AM
whiz999 Re: script for writing excel... 06-02-2009, 11:35 AM
  1. #1
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: script for writing excel values into specific locations in a text

    You would need to read the text file into a variable either enmass or line at a time.
    Then use INSTR functions to locate text and LEFT/MID/RIGHT functions to update text.
    You will also need to write the text file back to disk

    Post what you have already along with the text file.
    Cheers
    Andy
    www.andypope.info

  2. #2
    Registered User
    Join Date
    06-01-2009
    Location
    U.S.A.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: script for writing excel values into specific locations in a text

    Thanks for responding. Quite honestly, I'm not sure where to begin. What I'm trying to do is look at other similar scripts and try to modify them to work with my requirements, but I'm totally lost. Any help with this simple(i think) script would be a godsend. I'm not proficient enough in VB, or any other program language, to create my own scripts.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1