Hello all,
So it seems simple, but as part of an excel import I use some automated formatting to match my excel to my table structure. Recently I tried to modify it to remove the "periods" in my name field. However, I keep receiving a subscript out of range error. I also receive this error after multiple subsequent imports, but it appears to be random on that end. It gives me the error each time this part of the code is run.
Thanks for any help on this one.
Scott
So it seems simple, but as part of an excel import I use some automated formatting to match my excel to my table structure. Recently I tried to modify it to remove the "periods" in my name field. However, I keep receiving a subscript out of range error. I also receive this error after multiple subsequent imports, but it appears to be random on that end. It gives me the error each time this part of the code is run.
Code:
objXLApp.Cells.Replace What:=".", Replacement:=" ",
LookAt:=xlPart, SearchOrder _:=xlByRows, MatchCase:=False,
SearchFormat:=False, ReplaceFormat:=False
Scott