Hello
I use the following code to open a txt file. The file is updated every
minute with ne values. How can I Update this file automatically after the
update?
Thanks

Sorry for the misleading subject. Started with one question I was going to
ask and some one came in and I got derailed.
Thanks for all replies!

"Sandy" wrote:

Hello
I use the following code to open a txt file. The file is updated every
minute with ne values. How can I Update this file automatically after the
update?
Thanks

following code

?

--
Jim Rech
Excel MVP
"Sandy" wrote in message
...
| Hello
| I use the following code to open a txt file. The file is updated every
| minute with ne values. How can I Update this file automatically after the
| update?
| Thanks
|
|

Sorry!


Workbooks.OpenText Filename:="C:\Mypath\myfile.txt", _
Origin:=437, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True,
Semicolon:=False, _
Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(Array(1,
1), _
Array(2, 1)), TrailingMinusNumbers:=True
ActiveWorkbook.SaveAs Filename:= _
"C:\Mypath\myfile.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWorkbook.Close
Application.DisplayAlerts = True
Applications.ScreenUpdating = True

Opens txt file and saves as xls file


"Jim Rech" wrote:

following code

?

--
Jim Rech
Excel MVP
"Sandy" wrote in message
...
| Hello
| I use the following code to open a txt file. The file is updated every
| minute with ne values. How can I Update this file automatically after the
| update?
| Thanks
|
|