Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi again. I'm trying to open a csv file with a simple macro (which is just gonna help someone, like a step by step), but my problem is that when I use - Dim x As Variant x = Application.GetOpenFilename("Fichiers CSV (*.csv), *.csv") Workbooks.Open Filename:=x- (which is msdn code), I will open the CSV as a text file, showing in A1 all my cells separated by semicolumns, instead of opening it as a really comma-separated values in different cells! Any idea how to solve that? Thanks -- lonfnico ------------------------------------------------------------------------ lonfnico's Profile: http://www.excelforum.com/member.php...o&userid=33396 View this thread: http://www.excelforum.com/showthread...hreadid=532572 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
Opening files in Excel 2003 saved in Excel 2000 without data loss... | Excel Discussion (Misc queries) | |||
Trouble opening large size Excel file 155Mb in Excel 2007 | Excel Discussion (Misc queries) | |||
REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming |