I've encountered a bit of an odd one. I am opening a tab delimited file, which has been sved as an xls.
When I open from file manager, it opens correctly. When I open from Excel, I have to go through 3 screen dictating how the data is set up, and the end result is that a couple of the numbers come through as text, rather than numbers.
Does anyone know why?
Failing an explanation - how do you open workbooks as file system objects - currently I am opening them using
Workbooks.Open Filename:=wb.Path & "/" & ws.Range("B1").Value
If I open them by mimicking the FM, perhaps it will work OK.
Thanks in advance,