open *.csv file as *.xls makro
 

How to ask user about path and open synteza.csv file as column separate
view
like synteza.xls?

Workboks.Open open it only as csv.

I ask to makro of course.

Thanks and sory for fatal English

--
kajr
-----------------------------------------------------------------------
kajro's Profile: http://www.excelforum.com/member.php...fo&userid=2877
View this thread: http://www.excelforum.com/showthread.php?threadid=48469

open *.csv file as *.xls makro
 

Try this:

Dim fileToOpen As Variant
fileToOpen = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
If fileToOpen = False Then
' user pressed cancel or some other error deal with it
End If
Workbooks.OpenText Filename:=fileToOpen, DataType:=xlDelimited, Comma:=True


"kajro" wrote:


How to ask user about path and open synteza.csv file as column separated
view
like synteza.xls?

Workboks.Open open it only as csv.

I ask to makro of course.

Thanks and sory for fatal English.


--
kajro
------------------------------------------------------------------------
kajro's Profile: http://www.excelforum.com/member.php...o&userid=28779
View this thread: http://www.excelforum.com/showthread...hreadid=484694