Convert xls for vba

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
Convert xls for vba

VB How-To Ask your "How do I do this with VB?" questions in this forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 7th, 2004, 02:11 PM

state

state is offline

Registered User

Join Date: May 2004

Posts: 4

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to state

Default

Convert xls for vba

Hi, Im sorry if this is in the wrong section(am new here).

I need to write some code to convert xls files to coma separated txt.
I'm clueless

Thanx

Old

September 30th, 2004, 06:29 AM

Lalit_Pratihari Lalit_Pratihari is offline

Lalit_Pratihari is offline

Authorized User

Join Date: Sep 2004

Posts: 55

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to Lalit_Pratihari

Default

Hi,

Use VBA. Create an excel object, navigate through the cells and wrtie them in a text file as comma separated values using FileSystemObject.

Thanks,
Lalit

Life Means More...;)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert Excel(xls) contents into HTML	manish.sharma04	XSLT	1	July 29th, 2013 04:42 AM
Convert VBA Add-in to .DLL	neodjandre	VB How-To	0	October 27th, 2008 01:23 PM
convert PDF file to XLS for Excel	crmpicco	Classic ASP Basics	2	November 30th, 2005 05:51 AM
convert vba code to vb	tommy03	VB How-To	3	February 23rd, 2005 02:13 PM
VBA code convert to SQL	omnicap1	Access VBA	2	August 23rd, 2004 03:03 AM