Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Troubles opening a CSV file from code

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
opening an excel file opens a duplicate file of the same file skm Excel Discussion (Misc queries) 1 December 7th 05 05:52 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 3rd 05 03:40 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 2nd 05 03:39 PM
saving *.xls files but troubles with opening with MS Excel Mimo Excel Programming 0 July 25th 03 03:04 PM


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"