Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA 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 23rd, 2011, 01:29 PM
Registered User
 
Join Date: May 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Converting Excel to CSV format

i am new to VBA
I need to convert excel data to csv format & save it on server location
can someone help me with this
 
Old May 23rd, 2011, 04:11 PM
JP JP is offline
Authorized User
 
Join Date: Apr 2008
Posts: 57
Thanks: 1
Thanked 3 Times in 3 Posts
Default

You haven't explained why you need VBA to do this.

In Excel 2003, I just go to the file menu and choose CSV format. I can save the file to any folder, network or local.
__________________
Regards,
JP
JP SoftTech
 
Old May 24th, 2011, 05:58 AM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default

Not sure why the person would need to explain to you why they need to do this JP.

Anyway, try recording a macro, then altering that code to your needs.
 
Old May 24th, 2011, 07:41 AM
Registered User
 
Join Date: May 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Covert excel to csv

I have to do this on click of a button as this has to be done a number of times.
So can any1 help with the macro as i'm having no clue about it
 
Old May 24th, 2011, 07:47 AM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default

Do you know how to record a macro? If you have Office 2010, you'll need to make the "Developer" ribbon visible. Go to File > Options > Customize Ribbon, then check the "Developer tab" On the Developer tab you'll see "Record macro." Click it, name your macro, then do what you have to do. When you're done, click "Stop recording." Then on the developer tab you'll see "Insert," click that and insert a Command button, assign the macro you just recorded to it. That should get you started, you may have file naming issues to deal with
 
Old May 24th, 2011, 02:57 PM
JP JP is offline
Authorized User
 
Join Date: Apr 2008
Posts: 57
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Nobody needs to explain anything to me.

When most people ask for help and specifically want to use VBA, they usually mention that it's not for a one-time process. All I'm asking for is confirmation of that.

Thx!
__________________
Regards,
JP
JP SoftTech





Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV > XML (converting problems) Kabe XML 6 November 17th, 2008 09:46 AM
count the string from csv format sudhirbharti C# 1 March 25th, 2008 03:16 PM
Save a file in CSV format thru Excel VBA macro roli2712 Excel VBA 1 July 11th, 2007 03:05 AM
Change excel into csv format Ivanchan Excel VBA 4 July 5th, 2007 02:02 AM
exporting to csv format dazednconfused Beginning PHP 1 July 11th, 2003 03:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.