CSV Import Issues

[IrishCharm]

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

[Bob Phillips]

I fail to see what the point of F2 is, SCV files will not contain formulae.

[IrishCharm]

I fail to see what the point of F2 is, SCV files will not contain formulae.

Hi,

No - what i mean is if i have an Excel spreadsheet with formulae in it and in the same workbook i open and close csv files, pasting the data that i need - when i then go to calculate my original Excel spreadsheet the formulae do not calculate properly.

[Bob Phillips]

Maybe one of two things, calculation mode is being set to manual, or the data is formatting the target cells as text.