Change Script Output

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Change Script Output

Logged in as: Guest

arrSession:exec spGetSession 2,2,32013

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

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Change Script Output
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Change Script Output - 3/7/2006 3:49:40 PM

Navarre

Posts: 90
Score: 0
Joined: 10/19/2005
Status: offline

Hey guys,

I would like to change the way the following script out puts the information. Curenntly it does it to a generic HTM file, but what I would like to do is make it output to the next column in a specific Excel document.

Can anyone let me know what I need to change to make this happen.

Thanks

strComputer = "."
Set objExplorer = WScript.CreateObject("InternetExplorer.Application")
objExplorer.Navigate "about:blank"
objExplorer.ToolBar = 0
objExplorer.StatusBar = 0
objExplorer.Visible = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
objStartFolder = inputbox("Please input the directory you wish to display")
Set objFolder = objFSO.GetFolder(objStartFolder)
Set colFiles = objFolder.Files
For Each objFile in colFiles
Wscript.Echo objFile.Name
strHTML = strHTML & objFile.Name & "<BR>"
Next

objExplorer.Document.Body.InnerHTML = strHTML

Post #: 1

RE: Change Script Output - 3/7/2006 4:29:55 PM

ebgreen

Posts: 5069
Score: 31
Joined: 7/12/2005
Status: offline

There are lots of examples on outputting to Excel both in these fora and to be found on the web using google.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to Navarre)

Post #: 2

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Change Script Output

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts