Solved

Create *.cvs file, or xls from split array

Posted on 2008-10-11
5
839 Views
Last Modified: 2010-04-21
Through the help of this forum I've managed to make a VBScript that sucks in a txt file, parses it up, and spits out some legible data. I have it spit out a file that's in *.cvs format. The problem I have is that the file is not automatically picked up by Excel as an associated file. If I create a file w/ Excel and save it as *.cvs it does. I'm not sure what i'm not doing right. Do I need to write some special data to the file for the association to work?  Below is the code i've gotten working and doing exactly what I want, minus the Excel association. :)  
Set objFSO = CreateObject("Scripting.FileSystemObject") 'object to first file
Const intForReading = 1
 
strFile1 = "Text.txt"        						'Read file location, name
strFile2 = "Disabled.cvs"    						'write file location, name
 
Set objFile1 = objFSO.OpenTextFile(strFile1, intForReading, False)
arr1 = Split(objFile1.ReadAll, VbCrLf)  				'bring file into array
objFile1.Close 								'closes objec to read file
									
cnt = ubound(arr1)							'sets count to array length
 									
Set objFile2 = objFSO.CreateTextFile(strFile2, True)			'object for write file
for i=0 to cnt 								'loop for writing
	arr2 = Split(arr1(i), "=")
	arr3 = Split(arr2(1), ",")
						
	objFile2.WriteLine arr3(0)					'writes to file
									'increments array count
Next
 
objFile2.Close
 
MsgBox "Done"

Open in new window

0
Comment
Question by:mmitchell57
  • 3
  • 2
5 Comments
 
LVL 50

Accepted Solution

by:
Dave Brett earned 250 total points
ID: 22695911
try a csv file
strFile2 = "Disabled.csv"
0
 

Author Comment

by:mmitchell57
ID: 22695931
oh heck.... attention to detail? :D
0
 

Author Comment

by:mmitchell57
ID: 22695932
Yep, i'm retarded. Thank you! :)
0
 

Author Closing Comment

by:mmitchell57
ID: 31505380
I failed to pay attention to detail! I appreciate BrettDJ being polite w/ his response.
0
 
LVL 50

Expert Comment

by:Dave Brett
ID: 22695956
:)

wev'e all been there

Cheers

Dave
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pass through dll 2 91
Attention Please 10 48
VB Script: create txt file with DateStamp and IP Adress 6 27
Modify file details 1 14
Welcome, welcome!  If you are new to the series and haven't been following along, please take a brief moment to review the first three installments: Part 1 (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/A_266-VBScri…
This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question