Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


How to convert XLS to CSV

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,26780
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How to convert XLS to CSV
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
How to convert XLS to CSV - 10/7/2005 1:23:54 AM   
  dasilva_john

 

Posts: 2
Score: 0
Joined: 10/7/2005
Status: offline 		Original message moved by Snipah
Reason : topic is general request..should fit in WSH & Clientside VBS
 I am fairly new to VBScript.  Does anyone know easiest way to create a script that will convert a XLS file to CSV format?
 
 
Post #: 1
 
RE: How to convert XLS to CSV - 10/7/2005 7:21:35 AM   
  Snipah


Posts: 1343
Score: 6
Joined: 11/1/2004
From: Netherlands
Status: offline 		Hiya,

Try the following (not fully error proof)


      

_____________________________

For more information, please see the "Read me First" topic.

http://www.visualbasicscript.com

(in reply to dasilva_john)
 
 
Post #: 2
 
RE: How to convert XLS to CSV - 10/11/2005 5:54:58 AM   
  Snipah


Posts: 1343
Score: 6
Joined: 11/1/2004
From: Netherlands
Status: offline
quote:


Hi,

Thanks for your help.  I was able to get this script to work the only problem is that it prompts me when it saves the file.  Is there a way to remove all prompts

I need to run this automated with no manual intervention.  Thanks for your input.

John



I always use the .SaveAs option

_____________________________

For more information, please see the "Read me First" topic.

http://www.visualbasicscript.com

(in reply to Snipah)
 
 
Post #: 3
 
 
 
 

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 >> How to convert XLS to CSV 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




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI