Trying to write a vbscript for first time

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Trying to write a vbscript for first time

Logged in as: Guest

arrSession:exec spGetSession 2,2,1011

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Trying to write a vbscript for first time
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Trying to write a vbscript for first time - 4/27/2004 11:02:19 PM

Looper

Posts: 2
Score: 0
Joined: 4/27/2004
From: United Kingdom
Status: offline

I am trying to write a vbscript that when run will do the following:-

1 - read data from a notepad file and take out all the numbers that appear i.e the file will be full of numbers but I only want it to take the number once, for example if the file contains the following 1,1,1,1,2,2,2, I want the script only to take 1,2 and insert these number into an excel workbook. nb - the notepad file does not contain commas.

2 - Then I want it to automatically save the excel workbook and close

3 - This script will be run everyday, so I don't know how that will affect the save process.

Can anyone provide sample code for this and let me know if doing this with vbscripting is the right thing to do.

I hope I have made it clear, but I am having trouble understanding myself.

Thx
[V]