Dear All
When using open.text (using office excel 97 or later!), if the source data changes, excel will import the old data every time unless the source is separatly opened in IE browser and refreshed each time. I am assuming this is caused by caching somehow. Is there any way to refresh the cache in code or to make excel not use the cache to start with?
cheers
Jon
code:
Workbooks.OpenText Filename:=" Origin:=xlMSDOS, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= Array(Array(0, 1), Array(8, 2), Array(30, 1), Array(37, 1), Array(50, 1), Array(64, 1), Array(74, 4), Array(84, 1), Array(92, 1), Array(102, 1), Array(114, 1), Array(128, 1))
When using open.text (using office excel 97 or later!), if the source data changes, excel will import the old data every time unless the source is separatly opened in IE browser and refreshed each time. I am assuming this is caused by caching somehow. Is there any way to refresh the cache in code or to make excel not use the cache to start with?
cheers
Jon
code:
Workbooks.OpenText Filename:=" Origin:=xlMSDOS, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= Array(Array(0, 1), Array(8, 2), Array(30, 1), Array(37, 1), Array(50, 1), Array(64, 1), Array(74, 4), Array(84, 1), Array(92, 1), Array(102, 1), Array(114, 1), Array(128, 1))