How to save worksheet in .cvs format?

I'm need to save a worksheet to .cvs or .txt format but the drop down menu 
for Save As does not include these options. Any help? Thanks.
0
Carlannie (1)
4/21/2005 5:17:12 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
363 Views

Similar Articles

[PageSpeed] 15

What version of Excel.  2003 has those options (Save As type).  Did you use 
the down arrows to scroll down?

Carole O

"Carlannie" wrote:

> I'm need to save a worksheet to .cvs or .txt format but the drop down menu 
> for Save As does not include these options. Any help? Thanks.
0
CaroleO (115)
4/21/2005 6:19:03 PM
Reply:

Similar Artilces:

Find Worksheet name
I need to add code to a macro to name the active worksheet a value of specific cell in the workbook, if the specified Sheet Name alread exists in the Workbook the user should be alerted via a Msgbox to th fact that this Sheet name already exists and should select a differen sheet name -- Message posted from http://www.ExcelForum.com Hi maybe something like sub foo() dim rng as range dim name_val set rng = activesheet.range("A1") name_val=rng.value on error resume next activesheet.name=name_val if err.number<>0 then msgbox "name already exist" rng.clearcont...

CSV error when trying to save
I'm using Windows Vista X86 and Word 2007 and I'm trying to save a workbook in the CSV file format. Everytime I save, it gives an error saying the file name.csv may contain features that are not compatible with CSV (Comma delimited). I was wondering if I would lose data or if data would be corrupted because of this? Many Thanks Brandon G. It is not an error, it is a warning, just letting you know that the csv will contain plain text, no formatting, no formulas, etc. "Brandon G" wrote: > I'm using Windows Vista X86 and Word 2007 and I'm tryin...

Address Format Problem
I am using Pocket PC 2002 and I'm trying to send email via active sync to MS Outlook 2002 and I'm experiencing problems. ActiveSync transfers the email from Pocket Outlook over to the Outlook 2002 (desktop) outbox, however, it drops it into the outbox with quotations around the email address (in the To: field). For example, the email address will read as follows: 'jdoe@sbcglobal.net' The quotations then cause the following error reply from my ISP: Message from yahoo.com. Unable to deliver message to the following address(es). <'jdoe@sbcglobal.net'>: Sorry, I c...

Tiff format problems with Access 2007
We have some databases created in Access 2000 with .tif files embedded to the forms and reports. And we are planning to migrate to Access 2007. We open databases created in Access 2000 with Access 2007 and we get the following error massage: 2114 <database name> doesn't support of the file 'I:\Tmimage\2005\20051028.tif,' or file is too large. Try converting the file to BMP format. Is Access 2007 supports tif format or is there any solution for this problem? The TIFF graphics filter was withdrawn in Office 2003, so many users with tiff images found that their app...

why does the zip+4 get deleted when saving and excel file as a DBF
Each time I try to export, to dbf, an address list created in Excel it deletes the Zip+4 when in the xxxxx-xxxx format I need, Please help. In my simple test, the digits didn't get deleted, but the formatting was gone when I reopened the .dbf file in excel. If I typed in the zip+4 as text (preformat the cells as text or started with a leading apostrophe '12345-1234), then the text was kept in tact. KevinPlays wrote: > > Each time I try to export, to dbf, an address list created in Excel it > deletes the Zip+4 when in the xxxxx-xxxx format I need, Please help. -- Dave...

Shared worksheet and SAMBA
Hi Does anyone use SAMBA to allow users to access shared excell file and then save the changes ? ...

formatting columns #3
This is the first time I've posted to this group. I have some how managed to get by using Excel while never having any training with it. With that said here's my question/problem. I also use Access and I'm exporting a query from Access to Excel. The query has many dimensional entries. An example would be; Part # 1 Hole Size 1 Hole Size 2 Hole Size 3 2.000 2.001 2.004 Part # 2 Hole Size 1 Hole Size 2 Hole Size 3 2.001 1.999 2.002 Part # 3 Hole Size 1 Hole Size 2 Hole Size 3 2.002 2.001 2.003 ...

Reading data from cells on a worksheet into a textbox
How do you read data from cells on a worksheet into a textbox on a data entry form? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ something like :- mystring = ActiveSheet.Range("A1").Value Me.TextBox1.Text = mystring ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ...

Importing bank statement that has a different date format
Is there a way import a money format statement file that has a different date format? I use mm-dd-yyyy format in my Money but i would like to import statements that have the dd-mm-yyyy format! Curretnly i open the file in notepad and manually change the dates and then import the file into money. It would be nice to have an option to automate this during the import process! Thanks VJ ...

Cell formatting protection
Here is my delima. I have excel 2002 and i have a sheet that i do no want anyone editing without entering in a password to unprotect it. Currently i have every cell on the sheet locked. and I wanted to setu some advanced permissions so that certain users dont even have t unlock the file that part works great. This sheet background color are used to indicate if the data has been processed or not ( not m idea to do it that way ) so i want to make it so that if some rando person that is not specified in my permissions list tries to change th background color it wont let him without typing in a...

howto: saveas with file name from a cell in the current worksheet #2
see subject bob, You can do it with vba. Here's a small snippet that you can assign to a command button. Where "A1" is the cell that you are using to name the file. This will save in the last folder you saved to. ActiveWorkbook.SaveAs Filename:=Range("A1").Value HTH Bigpig "bob" wrote: > see subject BigPig, Thank you. I have that part, but what if I wanted to add in a specific folder to save it to? Where would I add the folder string? That's where my real issue is. Thank you again. ActiveWorkbook.SaveAs Filename:=???????Range("A1&...

Show only some formulas in a worksheet
In Excel 2007, in the formulas Tab, there is an option called "Show Formulas". When I check this option all formulas in the sheet are shown. Is there a way to show only some formulas? Thanks in advance Regards, Emece.- Hi, No all the formulas will be shown "Emece" wrote: > In Excel 2007, in the formulas Tab, there is an option called "Show > Formulas". When I check this option all formulas in the sheet are shown. Is > there a way to show only some formulas? > > Thanks in advance > > Regards, > Emece.- As...

is it possible to export my outlook email files to some standard format ?
I am trying to save all my email messages because I want to try to install linux. One might think there was some way to export your email file to some standard format, but alas It seems I can only export to Microsoft Outlook or Microsoft Exchange from Outlook Express 6. Where is the mail file located ? maybe I can decipher most of it with a perl script or something if there is no other means. Perhaps a linux program like one in open office can read it ? __/ [ surfunbear@yahoo.com ] on Sunday 27 August 2006 17:16 \__ > I am trying to save all my email messages because I want to try t...

Open and Save Files in Directory
I'd like to be able to select a directory and for each .xls file found in the directory 1) open the .xls file 2) write the name and date saved in another workbook (in this case "workbook report.xls") and 3) save and close the workbook. I have the shell of the loop but I'm missing the pieces where I've written comments. A solution for this would be greatly appreciated! Thanks. Sub OpenAndSaveFiles() Dim wkbk As Workbook Dim StrWkbk As String ' open a form that allows the user to select a directory i.e. C:\temp Workbooks("Workbook Report.xls&qu...

How do I remove outlook headers from my excel worksheet?
I can't figure out how to. I can't drag it off like I can other toolbars (formatting, etc.) I can't find anything about outlook in any of the submenus. I have XP, by the way, and I have no idea how the email stuff got into excel. By headers, I mean there is an email toolbar, where I can choose a from address and enter to addresses, and choose a priority, etc. It's really annoying. Maybe it's as simple as: File|Send to|"Uncheck" Mail recipient. That icon on "mail recipient" is difficult to distinguish between on and off (for me at least). ...

Formatting a cell with a concatenated formula
Sorry for the double post but I'm not sure which is the best forum fo this question so I've posted it in 2 different ones. I have a concatenated formula that pulls text from 2 different cells The 2 cells are formatted differently (i.e. 1 cell has blue text an the other cell has red text and a different font) and I want to kee these formats. However, the cell with the concatenated formula take the format of that cell. Is there anyway to do this -- andy281 ----------------------------------------------------------------------- andy2812's Profile: http://www.excelforum.com/member...

Custom number format always defaults last number to 0.
I am trying to format cells to input credit card numbers in Excell 2000. When I set up a custom number format for four sets of four numbers (####-####-####-####) the result always changes the last number to a 0. How do I overcome that? Excel only lets 15 digits be used in numbers To have the 16th number most people use text. "scubadave" wrote: > I am trying to format cells to input credit card numbers in Excell 2000. > When I set up a custom number format for four sets of four numbers > (####-####-####-####) the result always changes the last number to a 0. How...

cannot save email password
in setting up outlook i can enter the password and save it. however every time i exit outlook and logon again i have to re-enter the password. Any idea ? I'm not sure which version you are running, so I can't give you specifics, but here is the general idea. For instance, in outlook 2003, select tools, email accounts, view or change. Then select your mail account from the pop up and select change. There is an option in your mail account setup to enter your password. Be sure to click the "remember my password" button. It's similar in outlook 98 and outlook ...

Health Savings Account troubles
We have a Health Savings Account as part of our medical insurance plan. Employer contributes to the savings account and Employee has the option of participating in a tax deferred additional contribution. We set this up wrong. Employer contributions should be going to Code W on the W-2, but we have it set up so that Employee contributions (a deduction) are going to Code W. Does anyone else have this situation and how did you set up your HSA? These are fairly new and the way we set up was based on advice from a CPA. My W-2's are wrong - I also need to figure out how to correct the ...

Picture occasionally saving as an attachment
Hi, I have pictures saved with all my contacts, the majority all seem fine, except now when I add a new contact and picture and view by the Phone List there is an icon in the Sort By: Attachment column for these new contacts. Can someone explain why this is happening and how to remove. Thanks Jason ...

Conditional formatting
Using Excel 2003... Trying to compare cells J4:Q4 to cell F4. F4 will be colored yellow if F4>all cells in the range of J4:Q4 excluding blanks. If J4 is not >, color the cell (or cells if multiple exist with the same value) that have the lowest price in the range J4:Q4. Can anyone suggest the proper formula? Regards, Jon Sorry - found an error in the original post. Should be: If F4 is not >, color the cell (or cells if multiple exist with the same value) that have the lowest price in the range J4:Q4. "jmcclain" wrote: > Using Excel 2...

Date Format #7
I want to display dates in the European format dd/mm/yy. When I enter dates they appear in the American format mm/dd/yy. Format Cells > Date in Excel only gives me the American format. Regional Options in Control Panel are set to English (Ireland) with the date format dd/mm/yy. How can I change the date to European format in EXCEL? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial...

saving a form as a page
Hi there I am trying to save a form as a page. I opened the form, click on save as and a box pops up that has the option to save as a form or a page. I selected page than I get an error code that states: "There was an error loading the XML data file'C:\Documents and Settings\Local Settings\Temporary Internet Files\content.MSO\3B68C570.temp. Please make sure that the file is a properly formatted XML file. A semi colon character was expected" Does anyone know the steps to rectify this? -- Thank-you! Ruth On Thu, 21 Feb 2008 05:23:01 -0800, Ruth <Ruth@discussions.mi...

Automatically Protect/lock Worksheet In 24 Hours
I'm preparing an Technology downtime tracker in which the Managers have to put in details of the time dueto which they were un- productive....the file will remain open for for 24 hrs for each day, and after that, post 24 hrs...the file will be automatically locked showing some error msg like "Time Over For Changes" etc....this will continueuntil n unless i allow changes to be made after 24 hrs...kinna ADMIN access to the entire sheet......... Hi, You will need to use VBA if you want it to be automatic. Take a look at the OnTime command in the VBA area. -- If this helps, pl...

Filtering data to different worksheets
Hi all, I'm sue this should be really simple to do but I'm struggling to get i to work. I have a list of account numbers and who has keyed each one on. I want to filter down the list so that I have a seperate worksheet fo each person with all of the account numbers (plus other columns of inf ie. address, phone number) that they have done. I've tried vlookup but that, obviously, only looks up the 1st accoun number. Can anyone point out what I'm missing? Thank -- jappe ----------------------------------------------------------------------- japper's Profile: http://www...