 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / December 2007in which folder can you save a .CSV file?
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. 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 <chivag...@discussions.microsoft.com> 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. 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? > Hi > [quoted text clipped - 15 lines] > > locate the file in order to import the addressbook, I can find no such folder > > anywhere. I have tried using other folders unsuccessfully. Any other file type options? You really want "Text files ", altho I am surprised you don't have the "All files" option... Richard On Dec 28, 3:40 pm, chivagirl <chivag...@discussions.microsoft.com> 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 [quoted text clipped - 17 lines] > > > 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. Not really, that I can see. Let me tell you exactly what it is I'm trying to do and see if you can see what I'm doing wrong. I want to export my address book from peoplepc e-mail account so that I can cancel my account and then import that file to a new e-mail account. When I click on that option, it opens excel w/ the info. I go to 'save as' and where it says -save in, there is a file K6CLR1ER and it's a subfolder of the local disk (C:). It will save in that folder, but when I try to find the file to import it, I can't find it anywhere. So I just tried to save it in other random folders and get an error message every time. > Any other file type options? You really want "Text files ", altho I > am surprised you don't have the "All files" option... [quoted text clipped - 27 lines] > > > locate the file in order to import the addressbook, I can find no such folder > > > > anywhere. I have tried using other folders unsuccessfully. Change the "Save In" location to a "real" folder. > Not really, that I can see. Let me tell you exactly what it is I'm trying to > do and see if you can see what I'm doing wrong. [quoted text clipped - 40 lines] >>>> >>>>>anywhere. I have tried using other folders unsuccessfully. I've already tried that several times > Change the "Save In" location to a "real" folder. > [quoted text clipped - 42 lines] > >>>> > >>>>>anywhere. I have tried using other folders unsuccessfully. You say "there is a file K6CLR1ER and it's a subfolder of the.... ". Files are not sub-folders. If the file is in fact being created, you should be able to find it in Windows Explorer. It is not an Excel issue. If you can't find the file, it is not being created, in which case the "people pc" export routine is suspect. > I've already tried that several times > [quoted text clipped - 46 lines] >>>>>> >>>>>>>anywhere. I have tried using other folders unsuccessfully. There is no "All Files (*.*) " listed under File>Save As>File Type so that is not strange. File>Open>Files 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, File>Import and Export>Export to a File and follow your nose from there. If you don't see the CSV extension make sure My Computer>Tools>Folder Optiuons>View has "show all file extensions" checked. Gord Dibben MS Excel MVP >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 [quoted text clipped - 19 lines] >> > locate the file in order to import the addressbook, I can find no such folder >> > anywhere. I have tried using other folders unsuccessfully. I am totally unfamiliar working with Outlook, actually. If you could help me out with that I would appreciate it. > There is no "All Files (*.*) " listed under File>Save As>File Type so that is > not strange. [quoted text clipped - 35 lines] > >> > locate the file in order to import the addressbook, I can find no such folder > >> > anywhere. I have tried using other folders unsuccessfully. 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 >I am totally unfamiliar working with Outlook, actually. If you could help me >out with that I would appreciate it. [quoted text clipped - 38 lines] >> >> > locate the file in order to import the addressbook, I can find no such folder >> >> > anywhere. I have tried using other folders unsuccessfully. 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. > Which email application do you use? > [quoted text clipped - 47 lines] > >> >> > locate the file in order to import the addressbook, I can find no such folder > >> >> > anywhere. I have tried using other folders unsuccessfully. 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 File>Save As>Save As Type>CSV(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 >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. [quoted text clipped - 53 lines] >> >> >> > locate the file in order to import the addressbook, I can find no such folder >> >> >> > anywhere. I have tried using other folders unsuccessfully. I've done as you've suggested and then I try to open the file to resave it and get the message 'cannot access the file' > Ok > [quoted text clipped - 74 lines] > >> >> >> > locate the file in order to import the addressbook, I can find no such folder > >> >> >> > anywhere. I have tried using other folders unsuccessfully. I don't know what's going on there. For sure you saved as an Excel *.xls workbook but get the "cannot access the file" when you try to open it? What else is included in the message? From where are you trying to open the file? From File>Open in a running instance of Excel or from double-click in Explorer? Gord >I've done as you've suggested and then I try to open the file to resave it >and get the message 'cannot access the file' [quoted text clipped - 77 lines] >> >> >> >> > locate the file in order to import the addressbook, I can find no such folder >> >> >> >> > anywhere. I have tried using other folders unsuccessfully. actually, I got it all figured out I think. I just needed to set up my Outlook settings, first! > I don't know what's going on there. > [quoted text clipped - 89 lines] > >> >> >> >> > locate the file in order to import the addressbook, I can find no such folder > >> >> >> >> > anywhere. I have tried using other folders unsuccessfully. When did you switch from peoplepc to Outlook? But happy to hear you are moving closer. Gord >actually, I got it all figured out I think. I just needed to set up my >Outlook settings, first! [quoted text clipped - 92 lines] >> >> >> >> >> > locate the file in order to import the addressbook, I can find no such folder >> >> >> >> >> > anywhere. I have tried using other folders unsuccessfully. Thanks, everybody, for all your help. > I don't know what's going on there. > [quoted text clipped - 89 lines] > >> >> >> >> > locate the file in order to import the addressbook, I can find no such folder > >> >> >> >> > anywhere. I have tried using other folders unsuccessfully. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.