View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default in which folder can you save a .CSV file?

Ok

From peoplepc you choose to export the address book.

Excel opens and the info gets copied to an Excel worksheet.

Good so far.

You then go to FileSave AsSave As TypeCSV(comma delimited)*.csv

Give the file a name and "Save".

Now you can't find that *.csv file......is that correct?

Try saving as an Excel workbook into a known folder like My Documents and see if
you can find that.

If you do, open it and re-save as a *.csv to that folder.


Gord

On Sun, 30 Dec 2007 09:46:03 -0800, chivagirl
wrote:

I have always just used my isp e-mail which is peoplepc. Yes, I've looked at
the help files to see how to export and that obviously isn't much help.
There is just a link to export the address book and when I click on it, it
opens excel and transfers the info to there. But when I try to save it,
there is where I have the original problem.

"Gord Dibben" wrote:

Which email application do you use?

Have you looked at its help files to see how to export your addresses to *.csv
or other?

What has Excel got to do with exporting your address book to a *.csv file?


Gord


On Sat, 29 Dec 2007 13:27:02 -0800, chivagirl
wrote:

I am totally unfamiliar working with Outlook, actually. If you could help me
out with that I would appreciate it.

"Gord Dibben" wrote:

There is no "All Files (*.*) " listed under FileSave AsFile Type so that is
not strange.

FileOpenFiles of Type has the "All Files (*.*) "

To save your email address book as a *.CSV file you must do that though Oulook,
which I assume is your email client.

With Outlook open, FileImport and ExportExport to a File and follow your
nose from there.

If you don't see the CSV extension make sure My ComputerToolsFolder
OptiuonsView has "show all file extensions" checked.


Gord Dibben MS Excel MVP


On Fri, 28 Dec 2007 07:40:01 -0800, chivagirl
wrote:

okay, your'e not going to believe this but, I tried to do as you suggested
and when I tried to select 'all files', there was no 'all files' listed! Is
that strange or what? Any other suggestions?

"RichardSchollar" wrote:

Hi

Assuming you are doing this from Excel, when you go to the file open
dialog you need to modify the "Files of type" dropdown at the bottom
from "All Microsoft Office Excel Files" to (easiest) "All Files (*.*)"
- this way the csv files will show up listed in the folder.

And yes, you can save csv files to anywhere you can save Excel files.

Hope this helps!

Richard


On Dec 28, 6:22 am, chivagirl
wrote:
I am trying to save my e-mail addressbook as a .CSV file. When the save menu
opens, it lists a folder under the local disk (C:). But then when I try to
locate the file in order to import the addressbook, I can find no such folder
anywhere. I have tried using other folders unsuccessfully.