Free Microsoft Excel 2013 Quick Reference

Export (or save as) .csv with text delimiters

Has anyone found a way of coercing Excel 2000 to export .csv files with
delimiter text? e.g: as "Mickey Mouse","Minnie Mouse","Donald Duck"
not Mickey Mouse,Minnie Mouse,Donald Duck

Thanks

Caroline

--
CarolineP
------------------------------------------------------------------------
CarolineP's Profile: http://www.excelforum.com/member.php...o&userid=20007
View this thread: http://www.excelforum.com/showthread...hreadid=345941


Does anyone know how to export data from an .xls file to a csv, and encode
all text fields with double quotes > ""?
I can use "save as" to get a csv file, but then the text does not have
double quotes.
any ideas?

Does anyone know how to export data from an .xls file to a csv, and encode
all text fields with double quotes > ""?
I can use "save as" to get a csv file, but then the text does not have
double quotes.
any ideas?

I believe this is a bug in Excel 2003. I get an error when saving as
CSV with VBA password protection turned on. If I turn off password
protection, the same code runs without error.

To reproduce the problem...

1. Open a new Excel file.
2. Type "Test" in Sheet1 cell A1
3. using Excel's Control Toolbox toolbar, draw a button on the
worksheet
4. right click on the button and select "view code"
5. enter the following line of code in the button click event (be sure
to enter a path that exists on your system -- I used "c:temp" which
did exist on my system):
ThisWorkbook.SaveAs "c:temptest.csv", xlCSVWindows
6. save your Excel file
7. click the button and observe that the VBA code runs without error
8. close the CSV file that you saved in step 7
9. re-open your Excel file that you saved in step 6
10. open the Visual Basic editor and select ToolsVBAProject Properties
from the menu
11. click the Protection tab, check the "Lock project for viewing"
checkbox, enter a password and click OK (this protects your VBA code).
12. close the Excel file
13. re-open the Excel file
14. click on the button you added in step 3 and notice the error.
"Run-time error '1004':
Method 'SaveAs' of object '_Workbook' failed
15. open the Visual Basic editor and attempt to view your code
16. when prompted for your password, enter it
17. click on the button you added in step 3 notice now the code runs
without error.

So it's clear that the same code runs fine when VBA password protection
is turned on or the password has been entered, or produces an error
when VBA password protection is turned off or the password has been
entered.

Any ideas how to correct this issue or work around it?

Thanks!

I believe this is a bug in Excel 2003. I get an error when saving as
CSV with VBA password protection turned on. If I turn off password
protection, the same code runs without error.

To reproduce the problem...

1. Open a new Excel file.
2. Type "Test" in Sheet1 cell A1
3. using Excel's Control Toolbox toolbar, draw a button on the
worksheet
4. right click on the button and select "view code"
5. enter the following line of code in the button click event (be sure
to enter a path that exists on your system -- I used "c:temp" which
did exist on my system):
ThisWorkbook.SaveAs "c:temptest.csv", xlCSVWindows
6. save your Excel file
7. click the button and observe that the VBA code runs without error
8. close the CSV file that you saved in step 7
9. re-open your Excel file that you saved in step 6
10. open the Visual Basic editor and select ToolsVBAProject Properties
from the menu
11. click the Protection tab, check the "Lock project for viewing"
checkbox, enter a password and click OK (this protects your VBA code).
12. close the Excel file
13. re-open the Excel file
14. click on the button you added in step 3 and notice the error.
"Run-time error '1004':
Method 'SaveAs' of object '_Workbook' failed
15. open the Visual Basic editor and attempt to view your code
16. when prompted for your password, enter it
17. click on the button you added in step 3 notice now the code runs
without error.

So it's clear that the same code runs fine when VBA password protection
is turned on or the password has been entered, or produces an error
when VBA password protection is turned off or the password has been
entered.

Any ideas how to correct this issue or work around it?

Thanks!

Hi

I'm trying to write some script which will save a worksheet as a csv file. I can get it to create the csv, but the system requires that any text formatted values be enclosed by "".

So I wrote a little script which adds the "" around text values prior to saving as csv. To my bewilderment, the result was text surrounded by 3 sets of "".

So TEXT should be "TEXT" but came out """TEXT"""!

I've attached the original xls spreadsheet (Example Feeder.xls), the csv file produced by the main code below (Example Feeder.txt) and the csv prodcued by adding the code at bottom, which wraps all text values in "" prior to saving (Example Feeder (with quotes).txt).

Does anybody have any ideas what I'm doing wrong?

Dion

'Record batch name and location
varFeederDestinationXLS = varFeederDirectory & varBatchName & ".xls"
varFeederDestinationCSV = varFeederDirectory & varBatchName & ".1"

'Create file header
WSfeeder.Cells(1, 1).NumberFormat = "@"
WSfeeder.Cells(1, 1).Value = Format("FH", "@")
WSfeeder.Cells(1, 2).NumberFormat = "@"
WSfeeder.Cells(1, 2).Value = Format("READY TO PAY", "@")
WSfeeder.Cells(1, 3).NumberFormat = "@"
WSfeeder.Cells(1, 3).Value = "RTP" & Format(Date, "ddmmyy;@")
WSfeeder.Cells(1, 4).NumberFormat = "@"
WSfeeder.Cells(1, 4).Value = Format(Date, "ddmmyy;@") & "RWKN"

'Calculate batch total(£)
For varSourceRow = 2 To varLastRow
    If WSinvoice.Cells(varSourceRow, 11).Value = "" Then
        varBatchTotal = varBatchTotal + WSinvoice.Cells(varSourceRow, 8).Value
    End If
Next varSourceRow
    
'Copy invoices to tmpFeeder sheet
varTargetRow = 2
varInvoiceCountNo = 1
For varSourceRow = 2 To varLastRow
    If WSinvoice.Cells(varSourceRow, 11).Value = "" Then
        'Invoice header
        WSfeeder.Cells(varTargetRow, 1).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 1).Value = Format("IH", "@")
        WSfeeder.Cells(varTargetRow, 2).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 2).Value = Format("READY TO PAY", "@")
        WSfeeder.Cells(varTargetRow, 3).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 3).Value = Format("GBP", "@")
        WSfeeder.Cells(varTargetRow, 4).NumberFormat = "0;-0"
        WSfeeder.Cells(varTargetRow, 4).Value = Format(varInvoiceCountNo, "0;-0")
        WSfeeder.Cells(varTargetRow, 5).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 5).Value = Format(WSinvoice.Cells(varSourceRow, 7).Value, "@")
        WSfeeder.Cells(varTargetRow, 6).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 6).Value = Format("STANDARD", "@")
        WSfeeder.Cells(varTargetRow, 7).NumberFormat = "dd-mmm-yy"
        WSfeeder.Cells(varTargetRow, 7).Value = Format(Date, "dd-mmm-yy")
        WSfeeder.Cells(varTargetRow, 8).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 8).Value = Format(WSinvoice.Cells(varSourceRow, 4).Value, "@")
        WSfeeder.Cells(varTargetRow, 9).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 9).Value = Format(WSinvoice.Cells(varSourceRow, 3).Value, "@")
        WSfeeder.Cells(varTargetRow, 10).NumberFormat = "0.00;-0.00"
        WSfeeder.Cells(varTargetRow, 10).Value = Format(WSinvoice.Cells(varSourceRow, 8).Value, "0.00;-0.00")
        WSfeeder.Cells(varTargetRow, 11).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 11).Value = Format("30 DAYS NET", "@")
        WSfeeder.Cells(varTargetRow, 12).NumberFormat = "dd-mmm-yy"
        WSfeeder.Cells(varTargetRow, 12).Value = Format(Date, "dd-mmm-yy")
        WSfeeder.Cells(varTargetRow, 13).NumberFormat = "0.00;-0.00"
        WSfeeder.Cells(varTargetRow, 13).Value = Format("0", "0.00;-0.00")
        
        varTargetRow = varTargetRow + 1
        
        'Invoice line
        WSfeeder.Cells(varTargetRow, 1).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 1).Value = Format("TL", "@")
        WSfeeder.Cells(varTargetRow, 2).NumberFormat = "0;-0"
        WSfeeder.Cells(varTargetRow, 2).Value = Format(varInvoiceCountNo, "0;-0")
        WSfeeder.Cells(varTargetRow, 3).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 3).Value = Format(Left$(WSinvoice.Cells(varSourceRow, 5).Value, 6), "@")
        WSfeeder.Cells(varTargetRow, 4).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 4).Value = Format(Left$(WSinvoice.Cells(varSourceRow, 6).Value, 4), "@")
        WSfeeder.Cells(varTargetRow, 5).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 5).Value = Format("00000", "@")
        WSfeeder.Cells(varTargetRow, 6).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 6).Value = Format("00000", "@")
        WSfeeder.Cells(varTargetRow, 7).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 7).Value = Format("000000", "@")
        WSfeeder.Cells(varTargetRow, 8).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 8).Value = Format(WSinvoice.Cells(varSourceRow, 4).Value, "@")
        WSfeeder.Cells(varTargetRow, 9).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 9).Value = Format("ITEM", "@")
        WSfeeder.Cells(varTargetRow, 10).NumberFormat = "0.00;-0.00"
        WSfeeder.Cells(varTargetRow, 10).Value = Format(WSinvoice.Cells(varSourceRow, 8).Value, "0.00;-0.00")
        WSfeeder.Cells(varTargetRow, 11).NumberFormat = "0.00;-0.00"
        WSfeeder.Cells(varTargetRow, 11).Value = Format(WSinvoice.Cells(varSourceRow, 8).Value, "0.00;-0.00")
        WSfeeder.Cells(varTargetRow, 12).NumberFormat = "@"
        WSfeeder.Cells(varTargetRow, 12).Value = Format("EXEMPT", "@")
        WSfeeder.Cells(varTargetRow, 13).NumberFormat = "0;-0"
        WSfeeder.Cells(varTargetRow, 13).Value = Format("1", "0;-0")
        
        varTargetRow = varTargetRow + 1
        varInvoiceCountNo = varInvoiceCountNo + 1
    End If
Next varSourceRow
        
'Add footer info
WSfeeder.Cells(varTargetRow, 1).NumberFormat = "@"
WSfeeder.Cells(varTargetRow, 1).Value = "IF"
WSfeeder.Cells(varTargetRow, 2).NumberFormat = "0.00;-0.00"
WSfeeder.Cells(varTargetRow, 2).Value = Format(varBatchTotal, "0.00;-0.00")
WSfeeder.Cells(varTargetRow, 3).NumberFormat = "0;-0"
WSfeeder.Cells(varTargetRow, 3).Value = Format(varInvoiceCountNo - 1, "0;-0")

'Add quotes to values
Call AddQuotesToValues

'Create feeder files
Application.DisplayAlerts = False
Sheets("tmpFeeder").Copy
ActiveWorkbook.SaveAs Filename:=varFeederDestinationCSV, FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close
Application.DisplayAlerts = True

The code to add "" is as follows:

Sub AddQuotesToValues()
    Dim rngData As Range, rngCell As Range, varLastFeederRow As Integer
     
    varLastFeederRow = Sheets("tmpFeeder").Cells(5000, 1).End(xlUp).Row

    Set rngData = Sheet5.Range(Cells(1, 1), Cells(varLastFeederRow, 13)).SpecialCells(xlCellTypeConstants, xlTextValues)
    For Each rngCell In rngData
        rngCell.Value = """" & rngCell.Value & """"
    Next rngCell
End Sub


When using data in MS Excel, I frequently have a column with length 9 string
of all digits. If I want to export to Access or save as a *.csv, Excel
converts this to scientific notation and it cannot be converted back to the
original data.

I often have rows of 1100 or more, so manually entering a single quotation
mark at the beginning of each cell is out of the question.

Is there a way to turn off this conversion to scientific notation?
Highlighting the column then nsing Format>Cells>Text also converts everything
to scientific notation

Hi guys,
I have a spreadsheet of about 5,000 rows of product descriptions I am preparing for bulk upload to a website. I need to replace a few segments of data (description, price and url) within all cells in Row A with data from 3 other columns.

A1 contains html something like this:

<a href="http://abcd.com"><img class="alignleft" src="http:/abcd.com/abcd.jpg" ></a> DESCRIPTION <br><h2>Only PRICE </h2><br><br><a href="http://URL"></a>

B1 contains the actual "Description"
C1 contains the actual "Price"
D1 contains the actual "URL"

I need to somehow automate the process to insert data from B1, C1, D1 in the correct areas of A1, for all 5000 rows.

Is there a macro, or formula or something similar that will automate this for me? Its just an unbelievably slow process doing this manually.

The data in row A actually says "DESCRIPTION", "PRICE" "URL" so I hope that will make it easier to select the right portion of text when writing a formula.

But here's the kicker:
Since this is being uploaded, I need the final product to be a .csv file, which from what I understand, does not save formulas. So I need a formula (or 3 separate formulas) to handle the above replacements, and then somehow convert all formulas to plain text, so I can save as csv? Is that even possible?!

Please help!

Thanks in advance!

I need to save a worksheet as a CSV File. The sheet looks like this
colA colB colC colD
123456 460 29.12.04 31.12.04

in the text file this should look like this
"123456";"460";"29.12.2004";"31.12.2004"

but I get
123456;460;29.12.2004;31.12.2004

if I try to add the " to the cells with char(34) the text file looks like this
"""123456"";""460"";""29.12.2004"";""31.12.2004"""
which means, as soon as I try to add " in any which way, XL is adding even more " when saving as CSV or any other TXT format.

How can I get what I need?

Excel 2002 XP PC

Good Morning -

I have been working to display text of my 7 Column spreadsheet on a webpage. I have the sheet formatted as I want it to appear. I click "View or Save as Webpage" and All columns transfer to the Webpage view as I want Except One. Its a Column with a URL address in it.

It seems the problem is with Word Wrap. Other Cells with words and spaces display in blocks on the webpage view. The URL because of its continuous string of text does not. It Breaks the text at the end of the designated width and only displays the top line.

Example - If you Start a new Open Worksheet --

Insert this Text in Cell A1 --

Pyrex Glass Basket used in the Microchip manufacturing industry for washing wafers - each one is serial Numbered

Insert this URL Into A2

http://i44.photobucket.com/albums/f1...reStuff016.jpg

Select View as Webpage

With word Wrap formatted to ON, and column width selected, Cell A2 looks like this in th4e Worksheet. ( and thats how I want it to appear on the webpage ) ( Note that A1 with Word Wrap does display properly because there are spaces in it )

http://i44.photobucket.c
om/albums/f1...reStuff01
6.jpg

With Word Wrap on when viewed in WEBPAGE VIEW it only displays the text from the top line of the worksheet cell.

http://i44.photobucket.c

Without Word wrap it displays complete but way to long to use in my 7 column display.

If I insert spaces in the long text string in the worksheet;

http://i44.photobuck et.com/albums/f1...re Stuff016.jpg

with Word Wrap it displays in the worksheet as

http://i44.photobuck
et.com/albums/f1...re
Stuff016.jpg

and it displays in the WEBPAGE VIEW as

http://i44.photobuck
et.com/albums/f1...re
Stuff016.jpg

that is the format I need it to appear in but, the URL address is not valid because of the spaces.

How can I make this long URL string appear in word wrapped form in Excel's "View as Webpage" option ?

OR

How else can I lead viewers to that URL to View the item photos without using half my page width on just that one column ?

Thanks for Looking -

Hi!
When I create a new worksheet and format the cells as "text" so it retains
my input exactly as I input it & save it as a comma delimited csv file, close
it, reopen it, my formatting is not retained.

I went to this web site
http://exceltips.vitalnews.com/Pages...CSV_Files.html

and followed the instructions, but the last instruction said to save as .csv
again, but after that, it still looses the formatting upon reopening the file.

Example:
I input data = 11200000000000000000
I save as .csv & when I reopen it now displays as: 12233E+19
And it doesn't retain any leading zeroes. I even put a single apostrophe in
front of the leading zero, it isn't retained.

I don't ever remember having this problem with older versions of Excel.

Can anyone help?

Thanks!

I am having dificulty finding a way of saving a file in the format I need
for another application.
I have a file which has a number of fields enclosed in quotes and seperated
by commas. Some of these fields are text and some numeric though treated as
text, eg phone numbers. I can open the file with Excel, make changes I need
to but when it comes to saving I cannot figure out how to get the same
format again. It has to be comma seperated with each field in quotes and
carriage return at the end of a record.

Thanks for any help.

ChrisK

I have a macro that exports a file to a CSV file with the fields enclosed in quotes, however there in items in some of the fields that are already quoted is there a way to modify this macro to ignore quoted items:

for ex: <ul class="test></ul>
is becoming
<ul class=""test""></ul>

Public Sub OutputQuotedCSV()
Const QSTR As String = """"
Dim myRecord As Range
Dim myField As Range
Dim vFilename As Variant
Dim nFileNum As Long
Dim sOut As String

'Get a filename to save as
vFilename = Application.GetSaveAsFilename(filefilter:="Microsoft CSV files,*.csv", _
Title:="Save as CSV with fields in double quotes")

If vFilename = False Then Exit Sub 'User chose Cancel

nFileNum = FreeFile
Open vFilename For Output As #nFileNum
For Each myRecord In Range("A1:A" & _
Range("A" & Rows.Count).End(xlUp).Row)
With myRecord
For Each myField In Range(.Cells(1), _
Cells(.Row, 256).End(xlToLeft))
sOut = sOut & "," & QSTR & _
Replace(myField.Text, QSTR, QSTR & QSTR) & QSTR
Next myField
Print #nFileNum, Mid(sOut, 2)
sOut = Empty
End With
Next myRecord
Close #nFileNum
End Sub
nevermind it works correctly

Hi!
When I create a new worksheet and format the cells as "text" so it retains
my input exactly as I input it & save it as a comma delimited csv file, close
it, reopen it, my formatting is not retained.

I went to this web site
http://exceltips.vitalnews.com/Pages...CSV_Files.html

and followed the instructions, but the last instruction said to save as .csv
again, but after that, it still looses the formatting upon reopening the file.

Example:
I input data = 11200000000000000000
I save as .csv & when I reopen it now displays as: 12233E+19
And it doesn't retain any leading zeroes. I even put a single apostrophe in
front of the leading zero, it isn't retained.

I don't ever remember having this problem with older versions of Excel.

Can anyone help?

Thanks!

Excel 2007 Save As CSV - MS-DOS adds extra spaces in the comma-delimited
file. (My List Separator in Regional Settings is simply comma, not
space-comma or so.)

So, I get
MC-001A, 192.00 , 7.00 , 6.60 , 91.00 , V-TOP
instead of
MC-001A,192.00,7.00,6.60,91.00,V-TOP

How do I fix this? Thanks.

I am using Word 2003 on Windows XP.

Could someone please post an example of how to convert, export, or save a
Word document or page as a jpg, gif, or png programmatically using VBA?

Is it even possible?

Thanks much in advance.

Hi Guys
I keep getting a problem with a spreadsheet when I save as text delimited.
I have a spreadsheet with lots of skus, ranging from 001 to 1250
I have to change the format in the cell for eg 001 as it defaults to 1.
When I save the worksheet in text delimited it is 001.
When I open it again it is 1.
This has a big effect on product upload as the system I use does not recognize 1 the same as 001.
How can I easily prevent this from happening.

Any help is greatly appreciated.

Thanks
Neil

When I use save-as csv, the delimiter used by Excel is semi-colon and not
comma. Why is this? Is there a setup that I can use to ensure comma as the
delimiter?

All,

I'm using EXCEL VB to generate a Macro for a mainframe...I need a single quote in the generated script, which is working perfectly until I come to save as text or copy/paste...my generated macro is shown here:-

Description = MFS001 Configuration Script
[wait app]
[wait inp inh]
[pf6]
[wait inp inh]
[wait app]
[wait inp inh]
"TEST1
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
"AAA
[tab field]
[tab field]
[tab field]
[tab field]
"COF
[enter]
[wait inp inh]
[wait app]
[wait inp inh]
[enter]
[wait app]
[wait inp inh]
[pf6]

yet when copied/pasted or saved as text is comes across as shown below:

"Description = MFS001 Configuration Script
[wait app]
[wait inp inh]
[pf6]
[wait inp inh]
[wait app]
[wait inp inh]
""TEST1
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
[tab field]
""AAA
[tab field]
[tab field]
[tab field]
[tab field]
""COF
[enter]
[wait inp inh]
[wait app]
[wait inp inh]
[enter]
[wait app]
[wait inp inh]
[pf6]"

Is there anyway for the script to just SAVE AS IS or anyway for me to copy/paste into notepad/wordpad/textpad without the quotes. I know I can do a search replace, but I'd rather keep is as automated as possible.

Thanks

I am working on loading a database, and the older data (delimited text) files don't have some of the fields that the newer data has..
so my solution is to use excel to simply add those missing columns in the old data and leave all the values blank. finally save as csv to get back to delimited text (easy enough right?)

this works perfect for new columns that are sandwiched in between actual data, but when i append the new columns to the end of the row, i noticed a problem.

the csv file that excel produces has null values for the first 16 rows (what i want), but then seems to ignore those fields altogether for the rest of the file!

anyone ever ran into this? is there an option that i'm neglecting?

Hi all.
I have a XL sheet with one column containing tekst and values. It is
partnumbers. Some of these starts with trailing nulls (the number 0). Like
00AB25 or 00056P-SDF.

It is populated from SQL Server 2000 varchar(30) field.

When I save as .csv file XL removes the trailing 0's and the partnumber in
the csv file changes to AB25 and 56P-SDF. Any ideas how to avoid this?

thanx.

geir

Below is a code to save historical price data in separate files. I.E. you type all the symbols you want to download in column A and each one's entire historical data will be saved in its own file titled with its respective symbol.

Question: I need these files in CSV format (currently xls); how do I edit this code to have the files save as csv files.

'If I change "xlNormal" to "lCSV" It asks me do I want to save every time, is there a way around this... so It just saves without the dialog box popping up?

Thanks in advance for the help!


	VB:
	
 
Sub Yahoo() 
     
    Dim cellvalue1 As String 
    Dim myfilename As String 
     
    Do While IsEmpty(Range("A1")) = False 
        cellvalue1 = Range("A1") 
        Range("B1").Select 
        ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ 
        "http://ichart.finance.yahoo.com/table.csv?s=" & cellvalue1 & "&ignore=.csv", TextToDisplay _ 
        :="http://ichart.finance.yahoo.com/table.csv?s=" & cellvalue1 & "&ignore=.csv" 
        Range("A1").Select 
        Selection.Copy 
        Range("B1").Select 
        Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True 
        ActiveWindow.Visible = False 
        Windows("table.csv").Visible = True 
        Range("M1").Select 
        ActiveSheet.Paste 
        myfilename = Range("M1") 
         'If I change "xlNormal" to ":xlCSV" It asks me do I want to save every time, is there a way around this... so It
just saves without the dialog box popping up?
        ActiveWorkbook.SaveAs myfilename, FileFormat:= _ 
        xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ 
        , CreateBackup:=False 
        ActiveWindow.Close 
        Rows("1:1").Select 
        Selection.Delete Shift:=xlUp 
        Range("A1").Select 
         
    Loop 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Fail to "save" or "save as" in Word 2007

I hope that someone out there can help me! I'm running Office 2007 with Windows XP. Everything was working just fine until the most recent Windows update just prior to this weekend.
Over the weekend I began noticing a problem. In Word, when creating a new document or saving an existing document with a new name, I am unable to save or "save as". When I attempt to save or save as, I hear an error sound, but nothing appears on the screen - no dialogue box, nothing.
The problem doesn't occur consistently. It happens more often than not, but not every time. If I reboot and then relaunch Word, I sometimes am able to save or save as.  I've tried launching Word in safe mode, but the problem occurs occasionally even in Safe Mode.
I've got all the latest updates for Office 2007. I've run diagnostics, anti-virus and spyware programs, you name it, and nothing fixes it. I have been unable to find a fix for my problem, and I've desperately hunted everywhere on the web.
Might anyone out there be able to help me to find a fix for this annoying and persistent issue? Thanks kindly in advance!

Hi Guys, I need to save an Excel Document as a CSV file. It is used to import into a particular apllication. The problem is that I need to have cell A showing 00 (format = text), and cell b showing 06/06/2008 (format = text).
This is fine in Excel, but when I save as CSV file it always formats Cell A to General and shows only one zero, and converts cell b to date format. When I do this in Excel97 it works fine, but in excel 2003 this doens't do what I want.

Thanks

I am saving a spreadsheet where the date format was:
mm/dd/yyyy
I needed to be YYYY-MM-DD
I did that using format/custom YYYY-MM-DD.
The problem is when I save as CSV ,close, open again, the format shows:
mm/dd/yyyy
I used Editplus, didn't save the comma delimited.
Please help