Results 1 to 5 of 5

Thread: Problem opening .csv files via EXCEL-VBA [used a workaround, forget it, thanks]

Threaded View

  1. Jul 2nd, 2003, 02:27 PM #1
    opus
    opus is offline

    Thread Starter
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Problem opening .csv files via EXCEL-VBA [used a workaround, forget it, thanks]

    Hi,
    I can't figure out why it seems impossible to corectly open a .csv file (Comma delimted) using
    VB Code:
    1. Workbooks.Open FileName:=FileName, Format:=6, Delimiter:=","
    It will open with the firtst cell in each row filled like "bla1,bla2,bla3" instead of putting the 3 bla'S into three seperate cells.
    But if I open that file with a doubleclick manually it will open correctly??
    Last edited by opus; Jul 3rd, 2003 at 02:16 PM.
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width