Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just upgraded from Excel 2000 to 2002, unfortunately a
functionality I use disappeared (or I am missing something). What I am trying to do is create an excel instance from an other VBA enabled program (iFix 2.6) and open a CSV file: Set objExcel = CreateObject("excel.application") objExcel.Visible = True objExcel.Workbooks.Open "test.csv" What happens is that the file is opened but the delimiters are not recognised (everything is just put into the first column). The weird thing is that when I omit the last line and open the file from the menu (file, open) everything works fine. I am using a french Excel version on Win2000 and I am convinced the regional settings are correct. Like I said: this worked fine in Excel 2000, why not in 2002?????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
saving *.xls files but troubles with opening with MS Excel | Excel Programming |