Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening CSV files and #NAME? error in certain cells
Trevor
thanks for response. My reservation about this approach is that I don't know where in the sheet the problem data will appear i.e. which cells may be starting with a hyphen. So having already opened the sheet, which in some cases may be very large, as they represent data downloads from a financial system, I don't want to "go back" and re-open the CSV file under a differnet set of instructions, but maybe I'll have to do this. Thanks Tim "Trevor Shuttleworth" wrote in message ... Tim just guessing that you might get away with formatting the column(s) as text before importing the data. Regards Trevor "Tim Childs" wrote in message ... Hi Have done a search of Google archives and found the following to help with identifying problem: If Range("A1").Text = "#NAME?" Then ... 'from J Walkenbach The problem relates to opening CSV files where users have in certain cells put in text starting with a hyphen, which generates the #Name? error. Has anyone some generalised code for replacing these cells (which can be anywhere on the sheet) - I am sure someone has been through this hoop before... Thanks for any tips/help Tim Other bits of code, I have started: Dim rTemp As Range Set rTemp = Cells.Find(What:="#Name?", After:=ActiveCell, LookIn:=xlValues, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False) 'now do replacing...something along the lines of (but not using selection in real code, of course): selection.value=chr(39)& mid(selection.formula,2,len(selection.formula)-1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening files error | Excel Discussion (Misc queries) | |||
Error opening Excel Files | Excel Discussion (Misc queries) | |||
Virus error opening all files | Excel Worksheet Functions | |||
data error while opening files | Excel Discussion (Misc queries) | |||
error opening .csv files | Excel Discussion (Misc queries) |