Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Saving .xls as a .csv file to open later as .dat

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was able to do this until I got a new computer running XP. Now I get an error message and a .csv file with no content is created. When I try to open it in WordPerfect or in Word, of course there's nothing to open.

    Is there another way to do this so I can get the .dat file for word processing?

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are you doing this manually? i.e. File|Save As and then choosing *.csv or are you looking to get this done using VBA?


  3. #3
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And, I should have added that I cannot open .txt and .csv files in Excel, either.

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm doing it manually, file-save as.

  5. #5
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's the error message that you're getting?

  6. #6
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The Excel message is:

    "filename.txt" cannot be accessed. The file may be read-only or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

  7. #7
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is this file located on a server or another networked machine? (Is this a WinNT or Win2000 server perchance?)

    If the answer is "yes", have you tried creating a text file on your machine and have you tried opening that from Excel?

  8. #8
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The file is on a network server, running Novell 4.2

    The error message is the same whether I try to open a .txt file in Excel or try to save an .xls file as a .txt

  9. #9
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, but have you tried opening a text file that is stored on your own hard drive in Excel?

    I get the feeling that this is a network problem and not a problem with Excel.

  10. #10
    New Member
    Join Date
    May 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried using my local drive and find that I'm able to do just about everything I need to do. I'll present it as a network issue to our systems manager.

    Thank you very much for your assistance and for sharinig your knowledge.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •