IrishCharm
07-03-2008, 03:24 AM
Hi,
Just wondering if anyone knows of any issues that may arise from importing .csv files into Excel? when i import files of format .csv into Excel it causes the excel to go all funny. It will not fully calculate, adn you have to F2 on individual cells, save close and then re-open for the file to calculate. The pc has plenty of memory, the .csv only has about 30k rows used etc.
Sarah
str_reportname = "R:\PRP100_LIVE2DM.CSV"
Workbooks.OpenText Filename:=str_reportname, Origin _
:=xlMSDOS, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0 _
, 1), Array(6, 1), Array(16, 1), Array(22, 1), Array(36, 1), Array(43, 1), Array(54, 1), _
Array(68, 1), Array(90, 1), Array(107, 1), Array(124, 1), Array(141, 1), Array(158, 1), _
Array(175, 1), Array(192, 1)), TrailingMinusNumbers:=True
Just wondering if anyone knows of any issues that may arise from importing .csv files into Excel? when i import files of format .csv into Excel it causes the excel to go all funny. It will not fully calculate, adn you have to F2 on individual cells, save close and then re-open for the file to calculate. The pc has plenty of memory, the .csv only has about 30k rows used etc.
Sarah
str_reportname = "R:\PRP100_LIVE2DM.CSV"
Workbooks.OpenText Filename:=str_reportname, Origin _
:=xlMSDOS, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0 _
, 1), Array(6, 1), Array(16, 1), Array(22, 1), Array(36, 1), Array(43, 1), Array(54, 1), _
Array(68, 1), Array(90, 1), Array(107, 1), Array(124, 1), Array(141, 1), Array(158, 1), _
Array(175, 1), Array(192, 1)), TrailingMinusNumbers:=True